Connectors

Overview

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 AnalyticsCreator to integrate with relational databases and 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.

How to access

Navigation tree

Connectors → CONNECTOR → Edit connector; Connectors → Add connector

Toolbar

Sources → Add

Diagram

Not applicable

Visual element

{SearchConnectors} → CONNECTOR → double-click

Screen overview

The first image below shows the main Connectors interface. The second shows the editor that appears when a new connector is created.

Connectors screen overview

 

Context menus access - Connectors - Where I can find it 

image-png-Jul-07-2026-04-37-57-7573-PM Connectors

 

ID Context Menu Option Description
1 Refresh Refresh all objects under Connector node
2 List connectors List your connectors for more info see - List connectors
3 Add connector Add ca  new connector for more info see - New connector
4 Import connector from file Opens a local file picker for .accon / .acconx connector export files and imports a connector definition into the repository.
5 Import connector from cloud Opens cloud file selection and imports a connector package from cloud storage into the repository.

 

A.1) Connectors - Example - Source -> Microsoft SQL Server Northwind Database



ID Context Menu Option Description
1 Set diagram filter Set a new diagram filter for the selected connector.
2 Add to diagram filter Add an additional condition to the current diagram filter for this connector.
3 Edit connector Open the selected connector for editing and update its settings.
4 Delete connector Delete the selected connector from the repository.
5 DWH Wizard Open the Data Warehouse wizard for this connector.
6 Refresh used sources Refreshes metadata only for sources currently used by the selected connector.
7 Refresh all sources Refreshes metadata for all connector sources.
8 Export connector to file Exports the selected connector to a local .accon/.acconx file.
9 Export connector to cloud Exports the selected connector package to cloud storage.
10 List scripts List scripts associated with this connector.
11 Add script Add a new script to this connector.
12 Run script Run a script for this two scenarios

1) Create ProxyDB for DirectConnector
Creates or prepares the ProxyDB objects required for DirectConnector usage with the selected connector.

2) Create source references by field name
Creates source references by matching fields with the same or corresponding names between source objects.

 

A.2) Connectors - Example - Sources -> Microsoft SQL Server Northwind Database


ID Command Description
1 Refresh Reloads the Sources branch for the selected connector.
2 DWH Wizard Opens the DWH Wizard from the selected connector source context.
3 List sources Opens the Sources list for the selected connector.
4 Create new source Creates a new source definition manually.
5 Read source from connector Opens the Create source wizard to read source metadata from the selected connector.
6 List scripts Lists object scripts available for the selected connector source context.
7 Add script Creates a new object script for the selected connector source context.
8 Run script  Run a script for this two scenarios

1) Create ProxyDB for DirectConnector
Creates or prepares the ProxyDB objects required for DirectConnector usage with the selected connector.

2) Create source references by field name
Creates source references by matching fields with the same or corresponding names between source objects.

 

A.3) Connectors - Example - Sources -> Table dbo.Categories  from Microsoft Northwind Database

ID Command Description
1 Locate in diagram Locates the selected source object in the dataflow diagram.
2 Set diagram filter Sets the diagram filter to focus on the selected source object.
3 Add to diagram filter Adds the selected source object to the current diagram filter.
4 Edit source Opens the Source page for the selected source object.
5 Delete source Deletes the selected source object after confirmation.
6 Add import Starts the import creation workflow for the selected source object.
7 Add export Starts the export creation workflow for the selected source object.
8 Refresh structure Refreshes the structure and metadata for the selected source object.
9 Preview data Opens a preview of the data available from the selected source object.
10 Show reference diagram Opens the reference diagram for the selected source object.
11 List scripts Lists object scripts available for the selected source object.
12 Add script Creates a new object script for the selected source object.

A.4) Connectors - Example - Sources -> Table dbo.Categories -> Columns 

ID Command Description
1 Refresh Reloads the Columns branch for the selected source table.
2 Edit source columns Opens the source-column editor for the selected source table.
3 List scripts Lists object scripts available for the selected source-columns context.
4 Add script Creates a new object script for the selected source-columns context.

A.4) Connectors - Example - Sources -> Table dbo.Categories -> Column

A.5) Connectors - Example - Sources -> Table dbo.Categories -> Constraints

 

 

A.6) Connectors - Example - Sources -> Table dbo.Categories -> References

 

 

ID Command Description
1 Refresh Reloads the Constraints branch for the selected source table.
2 List source constraints Opens the list of source constraints for the selected source table.
3 Add source constraint Creates a new source constraint for the selected source table.
4 List scripts Lists object scripts available for the selected source-constraints context.
5 Add script Creates a new object script for the selected source-constraints context.

 

A.7) Connectors - Example - Sources -> Table dbo.Categories -> References -> FK_Products_Categories 

ID Command Description
1 Edit source reference Opens the source reference editor for the selected source reference.
2 Delete source reference Deletes the selected source reference after confirmation.
3 List scripts Lists object scripts available for the selected source-reference context.
4 Add script Creates a new object script for the selected source-reference context.

A.8) Connectors - Example - Sources -> Table dbo.Categories -> IMP.Categories 

 

ID Command Description
1 Edit import Opens the Import page for the selected source-to-import mapping.
2 Delete import Deletes the selected import mapping after confirmation.

 

C) Source references


 

ID Command Description
1 Refresh Reloads the Source references branch for the selected connector.
2 List source references Opens the list of source references for the selected connector context.
3 Add source references Creates source references for the selected connector context.
4 List scripts Lists object scripts available for the selected source-references context.
5 Add script Creates a new object script for the selected source-references context.
6 Run script

 Run a script for this two scenarios

1) Create ProxyDB for DirectConnector
Creates or prepares the ProxyDB objects required for DirectConnector usage with the selected connector.

2) Create source references by field name
Creates source references by matching fields with the same or corresponding names between source objects.

C) Source references - > Example FK_CustomerCustomerDemo 

 

ID Command Description
1 Edit source reference Opens the source reference editor for the selected source reference.
2 Delete source reference Deletes the selected source reference after confirmation.
3 List scripts Lists object scripts available for the selected source-reference context.
4 Add script Creates a new object script for the selected source-reference context.

Related topics