Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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. 

Table of Contents
maxLevel2

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:

Note

Only a Sys Admin user can create a custom connector.

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 NameDescription
    1accessTokenThe Access Token obtained from the Authentication provider. This parameter is mandatory to be defined.
    2refreshTokenThe OAuth Refresh Token.
    3clientId

    The Client Id (App Key) associated with the app registered with the Authentication provider.

    4clientSecretThe Client Secret (AppKey Secret) associated with the app registered with the Authentication provider.
    5accessTokenSecretThe 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 using the Install Accelerator option of Migration Utility. 
  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.