1. Home
  2. Cloud
  3. Guides
  4. Tours
  5. Concepts
  6. Tools
  7. References
    1. Built-in Functions
    2. Incorta Component SDK
    3. Incorta Connector SDK
    4. Connectors
      1. AlloyDB
      2. Amazon Web Services (AWS) Athena
      3. Amazon Web Services (AWS) DynamoDB
      4. Amazon Web Services (AWS) RedShift
      5. Amazon Web Services (AWS) S3
      6. Apache Drill
      7. Apache Hadoop HDFS
      8. Apache Hive
      9. Apache Kafka
      10. Autoline
      11. Box
      12. Cassandra (Simba)
      13. Cassandra (Incorta)
      14. Cisco Meraki
      15. Cosmos DB
      16. Custom CData
      17. Custom SQL
      18. Dropbox
      19. File System (LocalFiles)
      20. Freshservice
      21. FTP
      22. Google BigQuery
      23. Google Cloud Storage (GCS)
      24. Google Drive
      25. Google Sheets
      26. GraphQL
      27. IBM DB2
      28. IBM Netezza
      29. JIRA
      30. JSON
      31. Kyuubi
      32. Local Files
      33. MariaDB
      34. Microsoft Azure Gen2
      35. Microsoft OneDrive
      36. Microsoft SharePoint
      37. Microsoft SQL Server
      38. Microsoft SQL Server (JTDS)
      39. MongoDB BI
      40. MySQL
      41. NetSuite - Saved Searches
      42. NetSuite - SuiteAnalytics
      43. NetSuite - SuiteQL
      44. NetSuite - Web Service
      45. OneLogin
      46. Oracle
      47. Oracle B2C Service
      48. Oracle Cloud Applications
      49. Oracle Cloud Applications V2
      50. Oracle CPQ
      51. Oracle EPM
      52. Oracle Essbase
      53. Oracle OTM/GTM
      54. Oracle Sales Cloud
      55. Oracle WMS
      56. PostgreSQL
      57. Presto
      58. Salesforce v2
      59. SAP ERP
      60. SAP Hana
      61. SAP Sybase IQ
      62. ServiceNow
      63. SFTP
      64. Smartsheet
      65. Snowflake
      66. Splunk
      67. Teradata
      68. Vertica
      69. XML
      70. Zuora
    5. Public API
    6. Security
    7. Visualizations
    8. SQL Interface
    9. Other
  8. Integrations
  9. Data applications
  10. Releases

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.

Important
  • 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

  1. Login to Incorta as a SuperUser.
  2. Go to the Marketplace > Connectors.
  3. Search for the needed connector.
  4. Select its card.
  5. Select Install.

Upgrade a connector

  1. Login to Incorta as a SuperUser.
  2. Go to the Marketplace > Connectors.
  3. Search for the needed connector.
  4. Select its card.
  5. Select Upgrade to install the latest version.
  6. (OR) select the down arrow next to the Upgrade button to choose a specific connector version to upgrade to.

Downgrade a connector

  1. Login to Incorta as a SuperUser.
  2. Go to the Marketplace > Connectors.
  3. Search for the needed connector.
  4. Select its card.
  5. 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

Box

Dropbox

Google Drive

JSON

OneLogin

OneDrive

Microsoft SharePoint

XML

Query Service

Athena

Apache Drill

Google BigQuery

Cassandra

Cassandra (Simba)

Azure Cosmos DB

Presto

GraphQL

Data Lake

S3

Microsoft Azure Gen2

Apache Hadoop

Local Files

FTP

SFTP

Google Cloud Storage

Custom

Custom CData

Custom SQL

Streaming Data

Apache Kafka

Other

Google Sheets

Data File

File System

Note: Files System connector

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.