Connectors

Configure a Connector so AnalyticsCreator can access the source technology used by your project. Each guide covers the connection settings and checks for one Connector type.

Choose the guide matching your source. Prepare the required driver, file location, endpoint, and authentication details, then follow the guide through testing and saving the definition.

Configure a connection to your source

Configure a Microsoft SQL Server (MSSQL) Connector
Enter SQL Server connection settings, test access to the intended source, and save the MSSQL Connector.
Configure an Oracle Connector
Configure the Oracle connection details, test the connection, and verify the saved Connector definition.
Configure a CSV Connector
Select the CSV source and configure the file settings used by the Connector before saving and checking the definition.
Configure an Excel Connector
Configure an Excel file connection and check the saved settings for the intended workbook source.
Configure an SAP Connector
Enter the SAP connection details required by your environment, test access, and review the saved Connector.
Configure an OData Connector
Configure the OData endpoint and connection settings, then test and save the Connector definition.
Configure a Direct Connector
Configure a Direct Connector and check the connection settings used to access the intended source.
Configure an OLEDB Connector
Select OLEDB, enter provider-specific connection details, test access, and verify the saved Connector.
Configure an ODBC Connector
Configure the ODBC driver connection string, test access to the data source, and verify the saved Connector.