XDataserver getting DB connection via XDatapool for service operation

You can get manager this way:

Manager := TXDataOperationContext.Current.GetManager;

Or you can simply do it this way if you don't use manager:

var
Statement: IDBStatement;
ResultSet: IDBResultSet;

Statement := TXDataOperationContext.Current.Connection.CreateStatement;
Statement.SetSQLCommand(TheSQLStatement);
ResultSet := Statement.ExecuteQuery;