Featured data support

Anitha Abraham

Updated September 22, 2024 17:11

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 2018.1 through 2023.1
NetSuite JDBC integrations
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:

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:

Celigo AI chatbot (text to SQL)