_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:
|
Comment | Text | User defined comment. |