TI-Job - access to db connection info

[SBrenner]

Hi,

I use a TI process to load data from a RDBMS into a cube. I specified the database in the TI-tab 'Datasource' (the entered data are 'name of data source', 'user', passwort' and the SQL).
Is it possible to use these data in my code? Because I have to write back log infos to the same database. I know I can open a new DB connection with "ODBCOpen", but to avoid errors I want to use the same data for username and passwort.

Are there any variables which hold the entered DB data?

Thx in advance.

Steve B.

[SBrenner]

I found it. The data are stored in the internal Turbo Integrator variables.
They are (in 9.4.x):

• DatasourceNameForServer
  DatasourceASCIIDecimalSeparator
  DatasourceNameForClient
  DatasourceASCIIThousandSeparator
  DataSourceODBOCatalog
  DatasourceType
  DatasourceASCIIQuoteCharacter
  DataSourceODBOConnectionString
  DatasourceUsername
  DataSourceODBOCubeName
  DatasourcePassword
  DataSourceODBOHierarchyName
  DatasourceCubeview
  DataSourceODBOProvider
  DatasourceDimensionSubset
  DataSourceODBOSAPClientID
  DatasourceASCIIDelimiter
  DataSourceODBOSAPClientLanguage