Page Comparison

Connectors help you connect to and exchange data with an application such as NetSuite, SAP, and Salesforce. While Adeptia Connect offers you some pre-bundled connectors, it also gives you the flexibility to add your own custom connectors. 

You can add a REST or JDBC based custom connector to the application. 

This section guides you on how to add a custom connector and what all you need to have to accomplish this task. 

Adding a REST based Custom Connector

To add a REST-based custom connector to your version of Adeptia Connect, you first need to create the Connector Package and the Implementation Package for that connector. The instructions to create these packages are on the following pages:

• Creating the Connector Package
• Creating Implementation Package

Complete the following steps to add a REST based custom connector.

1. Click Account > My Company.
2. In the left pane, click Connectors.
3. On the connectors' manage page, click Add Connector.
4. On the Add Connector page, provide a name and description for the connector in the respective fields with self-explanatory labels.

5. In the Select Connector Type field, select REST as the type of the connector.

6. In the Select Authentication Type field, select the authentication type/mode.

   Info
   For a REST type of Connector, there are two modes of Authentication, OAuth Based and API Token Based. Select Authentication Type as OAuth if the Connector requires OAuth authentication. Select Authentication Type as API Token based if you already have an access token and/or refresh Token.

   
   

7. Based on your selection of Authentication Type in the previous field, select either the OAuth Profile to be used or enter a comma separated list of key value pairs of Authentication Parameters.

   Info

   You also need to select the OAuth profile to be used for the OAuth process if you select OAuth based authentication. You need to provide the comma separated list of key value pairs of Authentication Parameters If you select Authentication Type as API Token based. The value of Authentication Parameters will be in the following format DisplayName:ParameterName:Default value:IsHidden:IsReadOnly. While the first two values are mandatory, the next three values are optional. You can use these three optional values for the following purposes. Default value - If you to have provide a default value for any of the fields/parameters. IsHdden - If you want to keep any of the parameter hidden IsReadOnly - If you want to keep any of the parameter as read only. For example: Access Token:accessToken, RefreshToken:refreshToken Client Id:clientId:21456

   Standard Authentication Parameter.

   The table below contains the standard parameters and their description. You need to name the standard parameters in the same manner as given the table.

   Sl. No.	Parameter Name	Description
   1	accessToken	The Access Token obtained from the Authentication provider. This parameter is mandatory to be defined.
   2	refreshToken	The OAuth Refresh Token.
   3	clientId	The Client Id (App Key) associated with the app registered with the Authentication provider.
   4	clientSecret	The Client Secret (AppKey Secret) associated with the app registered with the Authentication provider.
   5	accessTokenSecret	The Access Token Secret associated with the app registered with the Authentication provider.

   
   

8. Click Browse..., navigate to the location of the Connector Package zip file, and select the file to upload. 
9. In the Provide Date Format field, enter the date format.

10. In the Provide Time Zone field, enter the time zone. 

    Info
    The previous two fields, Provide Date Format and Provide Time Zone are optional and used to fetch incremental data.

    
    

11. Click Save.
    The newly added connector will now be visible on the connectors manage page. 
12. Add the Connector Implementation Package by completing the following steps:
    1. On the connectors manage page, click More Action (screenshot) against the new connector and select Add Implementation.
    2. Upload the zip file containing the connector runtime classes.

Adding a CDATA based Custom Connector

Follow the steps below to add a CDATA based custom connector.

1. Obtain the CDATA Accelerator for the required Connector from Support team.
2. Deploy this Accelerator. 
   Refer to this page to know how you can deploy the Accelerator. 
3. Once the Accelerator is deployed, the new CDATA driver is added to the list of available Database drivers for creating DBInfos.
4. Click Account > My Company.
5. In the left pane, click Connectors.
6. On the connectors' manage page, click Add Connector.
7. On the Add Connector page, provide a name and description for the connector in the respective fields with self-explanatory labels.

8. In the Select Connector Type field, select JDBC as the type of the connector.

9. In the Select Database Driver field, Select the Database driver to be used for this connector.

   Info
   The selected Database driver should be the one deployed through Migration Utility.

   
   

10. In the Provide Date Format field, enter the date format.

11. In the Provide Time Zone field, enter the time zone. 

    Info
    The previous two fields, Provide Date Format and Provide Time Zone are optional and used to fetch incremental data.

    
    

12. Click Save.

Using a CDATA based Custom Connector

When you use a CDATA based Custom Connector in a Template/Transaction or a Process Flow with OAuth authentication, you must ensure that you:

• Provide the Access Token, Refresh Token, Client Id, and Client Secret values in the Database Info activity associated with the Template/Transaction or Process Flow.
• Set the OAuthSettingsLocation parameter in the Database Info activity associated with the Template/Transaction or Process Flow to avoid overriding of the OAuth settings of any other Database Info activity you may have used.

  
  

  Info
  OAuthSettingsLocation defines the location of the settings file where OAuth values are saved when InitiateOAuth is set to GETANDREFRESH or REFRESH.