Connnectors
The Connectors menu in AnalyticsCreator defines metadata for establishing a connection to a source system. Each connector includes a name, a source type, and a connection string. These connections are used in ETL packages to access external data sources during data warehouse generation.
Function
Connectors allow the platform to integrate with relational databases or other supported systems. The connection string is stored in the project metadata and referenced during package execution. Each connector is project-specific and can be reused across multiple packages or layers.
Access
Connectors are managed under the Sources section in the AnalyticsCreator user interface. All defined connectors are listed in a searchable grid, and new entries can be created or deleted from this screen. Selecting New opens a connector definition form with metadata fields and a connection string editor.
Properties
| ID | Property | Description |
|---|---|---|
| 1 | ConnectorName | Logical name identifying the connector within the project |
| 2 | ConnectorType | Type of source system (e.g., MSSQL, Oracle, etc.) |
| 3 | ConnectionString | OLE DB or equivalent connection string used to connect to the source system |
The first image below shows the main Connectors interface. The second shows the editor that appears when a new connector is created.
Screen Overview
The image below shows the List Connectors interface with columns labeled for easy identification
New Connector Dialog
Properties
| ID | Property | Description |
|---|---|---|
| 1 | ConnectorName | Logical name identifying the connector within the project |
| 2 | ConnectorType | Type of source system (e.g., MSSQL, Oracle, etc.) |
| 3 | Azure source type | Type of Azure source type (e.g., Azure SQL, Azure Postgres, etc.) |
| 4 | ConnectionString | OLE DB or equivalent connection string used to connect to the source system |
| 5 | CFG.SSIS | Do not store connection string in CFG.SSIS_Configurations |
Screen Overview
The image below shows the New Connector interface with columns labeled for easy identification:
