Featured data support

Contents

• AS2 support
• Electronic data interchange (EDI) support
• Netsuite support
• Salesforce support
• Structured query language (SQL) support

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:

• Understand AS2 connections

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:

• EDI and fixed-width configuration
• Supported EDI and fixed-width templates
• Functions supported by the integrator.io EDI generator (to trading partner)
• Functions supported by the integrator.io EDI parser (from trading partner)

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 2016.2 through 2020.2
• RESTlet integrations
• NS File Cabinet – Access files with full CRUD actions

For more information:

• Integrate with NetSuite

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:

• Integrate with Salesforce

Structured query language (SQL) support

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

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.