Search Knowledge Base by Keyword

New Connector

< Back

From the Connector Library Management tab, you can create new connectors.  To create:

  1. Click the New Connector button to bring up the New Connector wizard
  2. Enter the properties of the new connector on the Connector Properties tab

    1. Image Preview – Upload image to display in the Connector Library (optional)
      1. Click the Change Image hyperlink and browse for an image to upload

      2. Click the Update button to upload the image. Click the Clear Selected File hyperlink to clear the file and browse for a new image.  Click the Cancel Changes hyperlink to cancel the operation.
    2. Identifier – Enter identifier of the connector (required)
    3. Name – Enter name of the connector (required)
    4. Description – Enter description of the connector (optional)
    5. Help URL – Enter help URL of the connector (optional)
    6. Order – Choose the order the connector is displayed in the Connector Library (optional)
    7. Enabled – Choose if the connector is enabled (required)
    8. Connector Job Types – Choose the type of connector jobs (required)
      1. Inbound Only
      2. Outbound Only
      3. Both Inbound and Outbound
  3. Click the Create button when finished to create the connector. You will be redirected to the Connector Properties tab to continue creating the connector. Click the Cancel button to cancel the operation.
  4. Create authentication methods for the new connector on the Authentication Methods tab

    1. Click the New Authentication Method button to bring up the New Authentication Method dialog
    2. Enter the properties of the new authentication method

      1. Name – Name of the authentication method (required)
      2. Description – Description of the authentication method (optional)
      3. Script – Name of the authentication script (required)
      4. Order – Order of the authentication method in the menu (optional)
      5. Enabled – Choose if the authentication method is enabled (required)
    3. Click the Create button when finished to create the authentication method. You will be redirected back to the Authentication Methods tab. Click the Close button to cancel the operation.
      1. The new authentication method function is only available to users in the Administrator security group
  5. Associate fields with the authentication method for the new connector on the Fields tab
    1. Select a field (row) to edit
    2. Click the Edit Field button on the toolbar to bring up the Edit Field dialog

      1. The edit button is grayed out unless a field (row) is selected

      2. The edit function is only available to users in the Administrator security group
    3. Update the properties of the field

      1. Enabled – Choose if the field is enabled (required)
      2. Field Name – Name of the field (required)
      3. Field Type – Type of the field (required)
      4. Field Label – Label of the field (required)
      5. Placeholder – Placeholder of the field (optional)
      6. Tooltip – Tooltip of the field (optional)
      7. Input Data – JSON input data of the field (optional)
      8. Min Length – Minimum length (number of characters) of the field (optional)
      9. Max Length – Maximum length (number of characters) of the field (optional)
      10. Default Value – Default value of the field (optional)
      11. RegEx Pattern – Regular expression pattern to validate input values of the field (optional)
      12. RegEx Message – Message to display for input values that do not match the regular expression pattern (optional)
      13. Order – Order of the field in the Activate New Connection dialog (optional)
      14. Required – Choose if the field is required (required)
    4. Click the Update button when finished to update the field. You will be redirected back to the Fields tab. Click the Close button to cancel the operation.
  6. Define the inbound job fields for the new connector on the Inbound Job Fields tab
    1. Select a job field (row) to edit
    2. Click the Edit Job Field button on the toolbar to bring up the Edit Job Field dialog

      1. The edit button is grayed out unless a job field (row) is selected

      2. The edit function is only available to users in the Administrator security group
    3. Update the properties of the job field

      1. Enabled – Choose if the field is enabled (required)
        1. The following inbound job fields are enabled by default and cannot be disabled: Order, Fields to Index, Data Identify, Destination Table, Enabled, Job Schedule, Job Description.
      2. Field Name – Name of the field (required)
      3. Field Type – Type of the field (required)
      4. Field Label – Label of the field (required)
      5. Placeholder – Placeholder of the field (optional)
      6. Tooltip – Tooltip of the field (optional)
      7. JSON Input Data – JSON input data of the field (optional)
      8. Min Length – Minimum length (number of characters) of the field (optional)
      9. Max Length – Maximum length (number of characters) of the field (optional)
      10. Default Value – Default value of the field (optional)
      11. RegEx Pattern – Regular expression pattern to validate input values of the field (optional)
      12. RegEx Message – Message to display for input values that do not match the regular expression pattern (optional)
      13. Order – Order of the field in the New Inbound Job and Edit Inbound Job dialogs (optional)
      14. Required – Choose if the field is required (required)
    4. Click the Update button when finished to update the inbound job field. You will be redirected back to the Inbound Job Fields tab. Click the Close button to cancel the operation.
  7. Create inbound job templates for the new connector on the Inbound Job Templates tab

    1. Click the New Inbound Job Template button to bring up the New Job Template dialog
    2. Enter the properties of the new job template (available job template fields differ by connector)

      1. Populate Job Record – Choose how to populate the job template (required)
        1. Clear Job Record – Start with an empty record
        2. Use Template – Start with a template job
      2. Job Description – Description of the job template (required)
      3. Job Schedule – Frequency the job template will run (required)
        1. Hourly
        2. Daily
        3. Weekly
        4. Every 5 Minutes
        5. Every 15 Minutes
        6. Every 30 Minutes
        7. Custom
      4. Enabled – Choose if the job template is enabled (required)
      5. Log Raw API Calls – Choose if raw API calls are logged (required)
      6. Allow Empty Table  – Choose if an empty table is allowed (required)
      7. Destination Table – Name of the destination table (e.g., my_table_cm_computer) (required)
      8. Data Identity – Identity of the data for dashboards (e.g., cm_computer) (optional)
        1. AD – Identity data to query from a table
      9. CSV/JSON/XML File or Path – CSV/JSON/XML file or path (optional)
      10. Append Files to Same Destination Table – Choose if multiple files in the same path will append to the same destination table, or will create a new destination table for each file (optional)
      11. Data Selection – Connector specific data selection command of the job template (optional)
      12. Fields to Index – Fields to index (optional)
      13. Data Node – Data node of the job template (optional)
      14. Method Type – Method type of the job template (GET, POST, PUT, PATCH, DELETE) (required)
      15. API End Point – API end point of the job template (optional)
      16. API Query Parameters – API query parameters of the job template (optional)
        1. Enter Key and Value pair for each API query parameter
        2. Click the Add API Query Parameters Field button to add API query parameters
        3. Click the Delete button to delete API query parameters
      17. API Return Data Node – API return data node of the job template (optional)
      18. Click View Pagination Fields to enter pagination properties of the job template
        1. Pagination Type – Paging type of the job template (Records, Pages, Next Record Node, Next Page Node) (optional)
        2. API Pagination Node – API pagination node of the job template (Next Page, Next Node) (optional)
        3. Pagination Offset Start – Request paging offset start or data node of the job template (optional)
        4. Pagination Limit – Request pagination limit of the job template (optional)
      19. Request Sort By Field – Field to sort the job template by (databases only) (optional)
      20. Request Unique Key Field – Request unique key field of the job template (optional)
      21. Request Limit – Request limit of the job template (optional)
      22. Request Filter – Fields to filter from the job template (optional)
      23. Pagination Termination Node – Pagination termination node of the job template (optional)
      24. Maximum API Calls – Limit of API calls that can be made by the job template to avoid an endless loop (optional)
      25. Click View Enumeration Fields to enter enumeration properties of the job template
        1. Enumeration Type – Enumeration type of the job template (API End Point, External Data, Other ETL Job) (optional)
        2. Enumeration Keys End Point – Enumeration keys end point of the job template (optional)
        3. Enumeration Node – Enumeration node of the job template (optional)
        4. Enumeration Key – Enumeration key of the job template (optional)
      26. Order – Order of the job template in the Activate New Connection dialog (required)
    3. Click the Create button when finished to create the inbound job template. You will be redirected back to the Inbound Job Templates tab. Click the Close button to cancel the operation.
      1. The new inbound job template function is only available to users in the Administrator security group
  8. Define the outbound job fields for the new connector on the Outbound Job Fields tab
    1. Select a job field (row) to edit
    2. Click the Edit Job Field button on the toolbar to bring up the Edit Job Field dialog

      1. The edit button is grayed out unless a job field (row) is selected

      2. The edit function is only available to users in the Administrator security group
    3. Update the properties of the job field

      1. Enabled – Choose if the field is enabled (required)
        1. The following outbound job fields are enabled by default and cannot be disabled: Order, Outbound Fields List, Return Data Fields List, Data Sending Method, Enabled, Job Description.
      2. Field Name – Name of the field (required)
      3. Field Type – Type of the field (required)
      4. Field Label – Label of the field (required)
      5. Placeholder – Placeholder of the field (optional)
      6. Tooltip – Tooltip of the field (optional)
      7. JSON Input Data – JSON input data of the field (optional)
      8. Min Length – Minimum length (number of characters) of the field (optional)
      9. Max Length – Maximum length (number of characters) of the field (optional)
      10. Default Value – Default value of the field (optional)
      11. RegEx Pattern – Regular expression pattern to validate input values of the field (optional)
      12. RegEx Message – Message to display for input values that do not match the regular expression pattern (optional)
      13. Order – Order of the field in the New Outbound Job and Edit Outbound Job dialogs (optional)
      14. Required – Choose if the field is required (required)
    4. Click the Update button when finished to update the outbound job field. You will be redirected back to the Outbound Job Fields tab. Click the Close button to cancel the operation.
  9. Create outbound job templates for the new connector on the Outbound Job Templates tab

    1. Click the New Outbound Job Template button to bring up the New Job Template dialog
    2. Enter the properties of the new job template (available job template fields differ by connector)

      1. Populate Job Record – Choose how to populate the job (required)
        1. Clear Job Record – Start with an empty record
        2. Use Template – Start with a template job
      2. Job Description – Description of the job template (required)
      3. Enabled – Choose if the job template is enabled (required)
      4. Log Raw API Calls – Choose if raw API calls are logged (required)
      5. Method Type – Method type of the job template (GET, POST, PUT, PATCH, DELETE) (optional)
      6. Data Sending Method – Data sending method of the job template (JSON Encoded Data, Form Data) (required)
      7. API End Point – API end point of the job template (optional)
      8. API Query Parameters – API query parameters of the job template (optional)
        1. Enter Label and Value pair for each API query parameter
        2. Click the Add API Query Parameters Field button to add API query parameters
        3. Click the Delete button to delete API query parameters
      9. Return Data Fields List – Return data fields of the job template (required)
        1. Enter Label and Data Object pair for each return data field
        2. Click the Add Return Data Fields List Field button to add return data fields
        3. Click the Delete button to delete return data fields
      10. Outbound Fields List – Outbound fields of the job template (required)
        1. Enter Label and Name and select Type (String, Numeric, Boolean) for each outbound field (required)
        2. Check Required if the outbound field is required (required)
        3. Check URI if the outbound field is passed through the URI (Uniform Resource Identifier) rather than the data packet (optional)
        4. Enter Pattern for each outbound field (optional)
        5. Click the Add Outbound Fields List Field button to add outbound fields
        6. Click the Delete button to delete outbound fields
      11. Ignore Empty Outbound Fields – Choose if empty outbound fields are ignored (optional)
      12. Order – Order of the job template in the Activate New Connection dialog (required)
    3. Click the Create button when finished to create the outbound job template. You will be redirected back to the Outbound Job Templates tab. Click the Close button to cancel the operation.
      1. The new outbound job template function is only available to users in the Administrator security group
Tags: