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 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. |