Data Sources

The table Data Sources contains a list of configured data source systems. Before you add a data source, you must configure a database connection in the Connections system table. In the Data Sources table, you define this database connection as a data source. To create a new element in the Data Sources table, double-click <New: ID> at the bottom of the ID column and specify the unique ID. Double-click the entry of the Connection ID column and specify the configured database connection name.

Column Description Required
ID Primary key of the element name, the unique identification of the element within the OLAP data model (no special characters, max. 72 characters). The ID in this table must be a number. The column Data Source ID is used in many tables and can be used to filter elements according to their data source. X
Data Source Name of the data source
Table Prefix Here you can define filters for data sources. For example, specify PK1 for a data connection to a database, if only tables starting with PK1 are to be displayed.
Connection ID Assignment of a data connection name configured in the system table Connections.
OEM to ANSI Select Yes, if you require the character code translation from OEM to ANSI for the new database connection.