CData Connector Setup

Version 21.0.8126


CData Connector Setup


The CData connector allows you to integrate CData into your data flow by pushing or pulling data from CData. Follow the steps below to connect ArcESB to CData.

Installing the CData Driver

You must install the ADO.NET provider (Windows edition) or JDBC driver (Java edition) for the appropriate data source before connecting to the data source.

ADO.NET

Follow these steps to download and run the CData installer for an ADO.NET provider:

  1. Find the the desired data source in the list of CData data sources. Click on the tile for a data source to bring up the page for that data source.

  2. Find the top toolbar that lists the available driver types and click on the ADO.NET tile.

  3. Click Download on the resulting page.

  4. Download the trial (30 days of full functionality) or the full provider (requires a purchased license). Contact the ArcESB licensing team at sales@cdata.com to arrange for provider licensing.

  5. Run the downloaded installer.

  6. Restart the Arc server to allow the CData Connector to detect the new provider.

JDBC

In order for the CData Connector to recognize a JDBC driver, you must install it and place it in the lib folder of the Java server hosting Arc.

  1. Find the the desired data source in the list of CData data sources. Click on the tile for a data source to bring up the page for that data source.

  2. Find the top toolbar that lists the available driver types and click on the JDBC tile.

  3. Click Download on the resulting page.

  4. Download the trial (30 days of full functionality) or the full driver (requires a purchased license). Contact the ArcESB licensing team at sales@cdata.com to arrange for driver licensing.

  5. Extract and run the setup.jar file from the downloaded archive.

  6. Navigate to the driver installation directory and find the driver .jar file and .lic (license) file inside the /lib/ folder.

  7. Copy the driver .jar and .lic files into the /lib/ folder of the Java server hosting Arc.

  8. Restart the ArcESB server to allow the CData Connector to detect the new driver.

Establish a Connection

To allow ArcESB to use data from CData, you must enter the connection credentials into each instance of the CData connector. Connections to CData can not be re-used across multiple CData connectors.

Follow these steps to establish a connection:

  1. Drag a CData connector into an ArcESB flow and give it a name.

  2. In the Connector Configuration pane, select the desired Driver from the drop-down menu.

  3. Authentication steps vary depending on the selected driver:
    • If connection fields appear, enter the requested information in each one and click Test Connection to ensure that ArcESB can connect to CData. If an error occurs, check all fields and try again.
    • If a Connect button appears, click it to sign into the driver via OAuth login.
  4. Click Save Changes.

Select an Action

After establishing a connection to CData, you must choose the action that the CData connector will perform. ArcESB can interact with CData in 4 ways. The table below outlines each action and where it belongs in an ArcESB flow:

Action Description Position in Flow
Upsert Inserts or updates CData data. By default, if a record already exists in CData, an update is performed on the existing data in CData using the values provided from the input. End
Lookup Retrieves a value from CData and inserts that value into an already-existing Arc message in the flow.
The Lookup Query determines what value the connector will retrieve from CData. It should be formatted as a SQL query against the CData tables.
Middle
Select Retrieves data from CData and brings it into ArcESB.
You can use the Filter panel to add filters to the Select. These filters function similarly to WHERE clauses in SQL.
Beginning
Execute Stored Procedures Treats data coming into the connector as input for a stored procedure, and then passes the result down the flow.
You can click the Show Sample Data button to provide sample inputs to the selected Stored Procedure and preview the results.
Middle