_Sources

The _Sources table describes the data sources of the dimensions and cubes to be loaded. The source are identified with a number in the other tables. The details are stored here.

The other metadata tables contain a column called SourceId. The ID read from the other tables is used to find the correct row in the _Sources table. If there is no entry, the appropriate table or view in the same database as the metadata tables is used. When looking up the source in the _Sources table, the source type and the connection parameters are read. Depending on the type, this can be either a direct connection string or the ID used to retrieve a connection string from a global data source.

This table describes _Sources:

Column	Type	Description
SourceId	Integer	Identifier for the source row in this table.
SourceType	Integer	Enumerator for type of source: 1 = SQL Server, Amazon Redshift, or PostgreSQL ODBC 2 = Aqua ODBC (Not yet implemented.) 3 = The connection string is obtained from EPM Administration.
ConnectionParameters	Text	Connection string to the source or a data source identifier used to look up the required connection string from EPM Administration. This is an example of a connection string: Driver={ODBC Driver 17 for SQL Server};Server=serverName\instanceName;Database=myDataBase;Trusted_Connection=yes;
Comment	Text	User defined comment.