ConnectIT Functionalities

Here is what ConnectIT 365 does for you

It is a powerful flexible tool for all your system integrations in Business Central where you can connect with all kind of services in all kinds of formats to import or export information in/ to other systems (and other Business Central environments as well).

Without using brookers or other middleware software!

Export management features:

  • Export files in many formats like XML, CSV, JSON and Excel.
  • Connect with API services like SOAP, FTP, SFTP, REST (endpoint), Azure Storage, Azure Service Bus, Azure Event Grid, Dropbox, e-mail, intercompany or mixed.
  • Synchronise data between different companies or between Business Central tenants
  • Synchronise data between Business Central and any other system
    Detailed formatting of data
  • Automatic field mapping with an easy to use by drag & drop a file into a wizard.
  • Add logic with standard functions on both header and line level.
  • Generate export definition based on samples
  • Advanced Schedular for your exports
  • Triggers based on record/field monitoring
  • Easy Backup/Copy/Share export definitions

Import management features:

  • Import files in many formats like XML, CSV, JSON and Excel
  • Import from API services like SOAP, FTP, SFTP, REST (endpoint), Azure Storage, Azure Service Bus, Azure Event Grid, Dropbox, e-mail, intercompany or mixed.
  • Generate import definition based on samples
  • Automatic field mapping with an easy to use by drag & drop a file into a wizard.
  • Add logic with standard functions
  • Validate data before importing
  • Advanced Schedular for your exports
  • Import data based on record/field monitoring
  • Easy Backup/Copy/Share import definitions

Connector features:

  • Inbuild middleware (works on Azure)
  • Connect to virtually any type or REST service
  • Supports Basic Authentication, Bearer tokens, OAuth 2.0, and the use of API keys
  • Supports both Azure Service Bus and Event Grid for integration.
  • Supports FTP and SFTP connection
  • Store files on Azure Storage.

Data monitoring features:

  • Automatically import/export on any change (records and fields)
  • Automatically import/export when data is added
  • Automatically import/export when data is deleted
  • Automatically import/export when a record is renamed

Job queue support:

  • Schedule your imports and exports through standard job queue mechanism
  • Or advanced inbuild schedular with a date formular and interval settings.

Pre- and post-processing:

  • Define integration projects
  • Add post processes like releasing a document after an import.
  • Define pre process tasks available to run a code unit before importing or exporting
  • Add tasks, import and export definitions and data transports

Advanced development features:

  • Add logic to imports and exports by storing data in variables
  • Call AL code via custom functions
  • Call external functionality via REST functions or Azure functions

Logging and Monitoring:

  • Detailed logging capabilities provide very precise insights into what happened
  • Set multiple alerts for each import and export definition
  • Full integration of Azure Application Insights Monitoring makes that you can use ConnectIT for all business-critical integrations
  • Use text messages (SMS & Whatsapp) for alert notifications

Specific tooling for Master data management:

  • Share master data between BC companies and between tenants, for example to make a connection with your supplier who also uses Business Central.

 

Return to support overview