Connectors → All
A connector specifies how the Loader Service connects to an external system or application and ingests data using a certain protocol, service, or Application Programming Interface (API). An instance of a connector with defined properties in a tenant is an External Data Source. You can create an external data source using a connector with the Data Manager. You can also develop your own connector using the Connector SDK.
Connectors Marketplace
Starting the 2024.1.0 release, Incorta moved the connectors catalog to the Marketplace tab. With the new Marketplace, you can install a connector, as well as upgrade, and downgrade your connector version independently from any Incorta releases.
- Only SuperUser has access to the Marketplace.
- You must contact your CMC administrator to enable CData connectors so you can install them from the Marketplace.
- After upgrading to 2024.1.0, you must contact Incorta Support to assist you with moving any custom SQL connectors that you have configured previously to the appropriate directory. In case of using a Data Agent, you must also copy the custom SQL JDBC driver jars to
incorta.dataagent/extensions/connectors/shared-libs/
on the Data Agent host.
In the Marketplace, the connectors are categorized according to their type and functionality. The connectors are displayed as cards within the Marketplace, each card contains the following information:
- Connector name
- Connector version
- Connector category
- Green tag if it is installed
- Yellow tag if it is new or has an available update
In a connector details page, you can view a brief description about the connector, a link to the connector’s full documentation, and a list of available updates (if it exists).
Within the Marketplace page, you can search for a connectors name and filter the connectors based on the following, knowing that by default all connectors are displayed:
- Installation status - Installed or Not Installed
- Category - Multi-selection for connectors categories
- Release Status - GA or Preview
- Connector Type - Incorta Native or CData Powered
For fresh clusters, the following connectors are installed by default:
- MySQL
- Oracle
- Microsoft SQL Server
- Custom CData
- Custom SQL
- Local Files
For upgrades from previous versions, used connectors will still exist, yet you must download any other connector that is not associated with a data source.
Install a connector
- Login to Incorta as a SuperUser.
- Go to the Marketplace > Connectors.
- Search for the needed connector.
- Select its card.
- Select Install.
Upgrade a connector
- Login to Incorta as a SuperUser.
- Go to the Marketplace > Connectors.
- Search for the needed connector.
- Select its card.
- Select Upgrade to install the latest version.
- (OR) select the down arrow next to the Upgrade button to choose a specific connector version to upgrade to.
Downgrade a connector
- Login to Incorta as a SuperUser.
- Go to the Marketplace > Connectors.
- Search for the needed connector.
- Select its card.
- Select the down arrow next to the Upgrade button and choose the connector version you want to downgrade to.
In most cases, you use a connector to create an external data source. To create an external data source, you can use the Data Manager.
Application
Autoline
DynamoDB
Cisco Meraki
Freshservice
Jira
Saved Searches
SuiteAnalytics
SuiteQL
Web Service
B2C Service
Essbase
Cloud Applications
Cloud Applications V2
Sales Cloud
Warehouse Management System
CPQ
OTM/GTM
Salesforce v1
Salesforce v2
SAP ERP
ServiceNow
Smartsheet
Splunk
Zuora
Database
AlloyDB
Apache Hive
IBM DB2
Kyuubi
MariaDB
MongoDB BI
MySQL
Netezza
Oracle
EPM
PostgreSQL
Redshift
HANA
Sybase IQ
Snowflake
Microsoft SQL Server
Microsoft SQL Server (jTDS)
Teradata
Vertica
File System
Query Service
Data Lake
Custom
Streaming Data
Other
Data File
It is not possible to create an external data source with the File System connector. LocalFiles is a built-in external data source that uses the File System connector. To extract data from a local data file, you can use LocalFiles as the Data Source type for a physical schema table.