ConnectIT 365 Functionalities

Here is what ConnectIT 365 does for you

It is a powerful flexible tool for all your system integrations in Business Central for advanced exchange of data with other systems (and other Business Central environments as well), by using all kinds of methods and file formats.

No need for additional middleware.

Export management features:

  • Export files in many formats like XML, CSV, JSON and Excel.
  • Connect with API services like SOAP, FTP, SFTP, FTPS, REST, REST endpoint , Azure Storage, Azure Service Bus, Azure Event Grid, Dropbox, e-mail, intercompany or mixed
  • Synchronize data between different companies or between multiple Business Central tenants
  • Synchronize data between Business Central and any other systems
  • Automatic field mapping with an easy to use by drag & drop a file into a wizard
  • Detailed formatting of data, add logic with standard functions based on multiple tables from Business Central
  • Use standard Business Central logic to export data.
  • Use flow tasks to group standard BC code units to trigger an action to automate the export process
  • Generate export definition based on samples
  • Real-time & Advanced Schedular for your exports
  • Triggers based on record/field monitoring
  • Easy to maintain with options for Backup/Copy/Share export definitions
  • Detailed logging

Import management features:

  • Import files in formats like XML, CSV, JSON and Excel
  • Importing from API services like SOAP, FTP, SFTP, FTPS, REST (endpoint), Azure Storage, Azure Service Bus, Dropbox, 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 using standard business Central logic before importing
  • Advanced Schedular for your exports
  • Use flow tasks to group standard BC code units to trigger an action to automate the import process
  • Easy to maintain with options for Backup/Copy/Share export definitions
  • Detailed logging

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
  • Azure Storage, Service Bus and Event Grid for integration.
  • Supports FTP and SFTP/ FTPS connections
  • Advanced Intercompany & multi tenant connections

Data monitoring features:

  • Automatically export on any change (records and fields)
  • Automatically /export when data is added
  • Automatically export when data is deleted
  • Automatically 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:

  • Automate the import / export process by using standard Business Central code units
  • Add post processes like releasing and posting 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
  • Group multiple tasks (multiple standard or custom codeunits)
  • Add custom code units

Advanced development features:

  • Define integration projects
  • 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
  • Permission sets available

Logging and Monitoring:

  • Advanced dashboard available about all the running interfaces
  • 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