Connect Composer v5 to Data Stores
Using connectors, Composer can connect to a wide array of data stores—from modern databases such as Hadoop, Search, Streaming, and NoSQL, to traditional sources like SQL-based stores. By default, your environment comes preconfigured with certain connectors enabled. However, additional connectors are available. If the connector you are looking for is not shown, it may be because:
- The connector is installed but is not enabled. For more information, see Managing Connectors and Connector Servers.
- The connector was not installed and needs to be downloaded separately. For more information, see Obtaining Additional Connector Servers.
- The connector requires you to provide a licensed JDBC driver. For more information, see Adding a JDBC Driver.
Certain connectors require a JDBC driver, which is obtained through a separate download. This allows you to select and add a driver that meets your operation needs or policies. The following connectors require a JDBC driver to be installed before configuring and connecting can occur: Amazon Redshift, MemSQL, MySQL, Oracle, SAP IQ, and Teradata.
To connect to a data store and use its data in a Composer visual, you must first verify that a connector and its connector server have been defined in Composer for the data store. See Managing Connectors and Connector Servers. Then you must define a data store connection and a data source configuration that uses the connection. The data store connection can be defined while you are setting up the data source configuration. See Managing Data Store Connections and Manage Composer v5 Data Source Configurations for more information.
|Composer supports only underscores and dashes in data store field names. No other special characters or white space are supported. If your data store uses special characters other than underscores and dashes in field names, please remove them before attempting to create a data source configuration.|
For information about what versions of data stores are supported by the Composer connectors, see Composer v5 Data Connector Reference. For information about which features are supported by different connectors, see Connector Feature Support.