Articles in this section

Featured data support

Anitha Abraham
Updated

AS2 support

When connecting to a trading partner via Applicability Statement 2 (AS2), rely on built-in features to meet all of the requirements and options:

  • Built-in connector – With no rate limit set at the Celigo AS2 endpoint

  • Certificate authentication – Self- and CA-signed

  • Content-based routing

  • Debug logs

  • Whitelisting

  • Encryption algorithms – DES, 3-DES, AES128, AES256, RC2

  • Signing algorithms – MD5, SHA1, SHA256

For more information:

Electronic data interchange (EDI) support

In addition to the long list of EDI templates, which grows with each release, the Celigo platform offers specialized functions to let you describe and categorize EDI data (X.12 and EDIFACT) for exports and imports.

For more information:

NetSuite support

In addition to a full suite of Integration Apps, templates, and documentation specifically designed for NetSuite customers, a host of purpose-built integration features tie directly to this popular ERP’s web framework.

  • Custom integration bundle – Installs in NetSuite to automate integration processes, with individual Celigo bundles available for Integration Apps and templates

  • SuiteScript hooks – Access custom code inside NetSuite for both exports and imports

    Specify the SuiteScript version (1.0 or 2.0) for an export, listener, or import

  • Import mapping – NetSuite source destination fields are easily human-readable, with simplified visual selection for mapping lists and subrecords

  • Event-based exports – Sync data based on events, such as Create and Update, in real time

  • WSDL (SOAP) integrations – Available for versions 2018.1 through 2023.1

  • NetSuite JDBC integrations

  • RESTlet integrations

  • NS File Cabinet – Access files with full CRUD actions

For more information:

Salesforce support

Beyond the expected API endpoint adapters, integrator.io includes several features tailored specifically to ease integrations with Salesforce, Salesforce.org, and FinancialForce:

  • Event-based exports – Sync data based on events, such as Create and Update, in real time

  • APEX triggers

  • REST, SOAP, and Composite APIs – Your choice at the import level; composite APIs create multiple parent-child records such as opportunities and line items

  • SOQL support

  • Import mapping assistant – Select fields as you would in Salesforce

  • Files/documents/attachments – Access files with full CRUD actions

For more information:

Structured query language (SQL) support

integrator.io connects to popular data warehouse systems and offers support for their – typically proprietary – SQL implementations:

  • Amazon Redshift

  • Google BigQuery

  • MySQL

  • NetSuite JDBC

  • Oracle DB

  • PostgreSQL

  • Salesforce SOQL

  • Snowflake

  • SQL

  • SQL Server

Several features make database queries as seamless as any API integration, including:

  • Reference stored procedures

  • Built-in SQL query Advanced field editor

  • Preview export queries against your data set

You can also connect to “NoSQL” database programs, such as MongoDB and DynamoDB.

Known limitation: Testing import queries directly in the editor is not supported. The “preview” is evaluated from sample data and does not impact your data set until the flow is run.

For more information: