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