Connectors

Connectors

The Connectors section in the Data Warehouse navigator is where all database or external source connections are defined and managed. Connectors provide the link between AnalyticsCreator and the physical data sources such as SQL Servers, data lakes, or cloud-based databases. Each connector allows you to organize and control the import and transformation of data through its defined sources and references.

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
Connectors Folder Refresh Reloads the list of all existing connectors from the repository. Updates the tree to show any newly added or removed connectors.
Connectors Folder List Connectors Displays a table of all connectors configured in the current project. Opens the Connectors overview dialog.
Connectors Folder Add Connector Creates a new connection definition to a database or data source. Opens the New Connector wizard for configuration.
Connectors Folder Import connector from file Imports a connector from a file. Reads the connector from your file.
Connectors Folder Import connector from cloud Imports a connector from cloud Reads the connector from AnalyticsCreator Private Cloud.

 

Screen Overview:

 DWH - Connectors

Sources

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
Sources
Folder
Refresh Reloads the list of all existing connectors from the repository. Updates the tree to show any newly added or removed connectors.
Sources
Folder
DWH Wizard Displays a table of all connectors configured in the current project. Opens the Connectors overview dialog.
Sources
Folder
List Sources Creates a new connection definition to a database or data source. Opens the New Connector wizard for configuration.
Sources
Folder
Create new-source Imports a connector from a file. Reads the connector from your file.
Sources
Folder
Read Source from the connector Imports a connector from cloud Reads the connector from AnalyticsCreator Private Cloud.
Sources
Folder
List Script Lists all scripts attached to the selected source in AnalyticsCreator. Opens the source-level script list for review or execution.
Sources
Folder
Add Script Creates a new script associated with the selected source. Opens the script editor scoped to the source; saves to project metadata.
Sources
Folder
Run Script Executes the selected source-level script in AnalyticsCreator. Runs the script against the current connection and logs results.

 

Columns

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
Columns
Folder
Refresh Reloads column metadata from project definitions and the source system (if connected). Refreshes the Columns node and updates the grid.
Columns
Folder
List source columns  Displays all detected source columns for the selected table or view. Opens the column list view in AnalyticsCreator.
Columns
Folder
List Script Shows scripts attached to column-level transformations or validation. Opens the column script list dialog for review or edit.
Columns
Folder
Add Script Creates a new script for column-level logic (e.g., formatting, checks). Opens the script editor scoped to the selected column(s).
Columns
Folder
Run Script Executes the selected column scripts within AnalyticsCreator. Runs the code and shows output in the Execution Log.

 

Constraints

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
Constraints
Folder
Refresh Reloads constraints from project metadata and source inspection (where supported). Refreshes the Constraints node in the navigator.
Constraints
Folder
List source Constraints Displays discovered PK/UK/Check constraints for the selected source object(s). Opens the constraints list in AnalyticsCreator.
Constraints
Folder
Add source Constraints Creates a new constraint definition in project metadata. Opens the constraint editor for configuration.
Constraints
Folder
List Script Shows scripts linked to constraint validation or maintenance.

Opens the constraint script list for edit or execution.

Constraints
Folder
Add Script Creates a new script for constraint management or checks.

Opens the script editor scoped to constraints.

Constraints
Folder
Run Script Executes the selected constraint script in AnalyticsCreator. Runs logic and logs output in the Execution Log.

 

References

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
References
Folder
Refresh Reloads reference mappings from project metadata and source discovery. Refreshes the References node in the navigator.
References Folder List Source references Displays detected foreign key/reference mappings for selected sources. Opens the references list view in AnalyticsCreator.
References
Folder
Add Source references Creates a new source reference mapping in project metadata. Opens the reference editor for configuration.
References
Folder
List Script Shows scripts related to reference creation, validation, or synchronization. Opens the reference script list for review or run.
References
Folder
Add Script Creates a new reference-level script for mapping or checks. Opens the script editor scoped to references.
References
Folder
Run Script Executes the selected reference script in AnalyticsCreator. Applies logic and updates mapping metadata; logs results.

 

Source References

Element Type Right-Click Option Name Description / Purpose Specific Action Performed
Source References
Folder
Refresh Reloads source reference entries from project metadata. Refreshes the Source References node in the navigator.
Source References
Folder
List Source references Displays source-to-source reference mappings grouped by object. Opens the list view for Source References in AnalyticsCreator.
Source References
Folder
Add Source references Creates a new source reference mapping entry. Opens the editor to define source reference details.
Source References
Folder
List Script Shows all scripts attached to source reference operations. Opens the reference script list for review or execution.
Source References
Folder
Add Script Creates a new script bound to source reference context. Opens the script editor with reference scope preset.
Source References
Folder
Run Script Executes the selected source reference script in AnalyticsCreator. Runs logic and writes details to the Execution Log.