ConnectIT 365

Design your own import and export interfaces - without coding - all directly in Microsoft Dynamics 365 Business Central

ConnectIT 365  

Importing sales or purchase orders, exporting inventory and price lists, creating data feeds and connecting online shops. These are just a few examples of what you can do with ConnectIT.

Microsoft Dynamics 365 Business Central has some import and export features like rapid start, but there are many cases in which these simply aren't sufficient. You want more control over your interfaces, more control over how data gets validated and processed, and more control over how data is structured and formatted. Perhaps you also want to schedule your imports or automatically export to an FTP server or call a web service when a specific record of even field is changed. 

That is why we created ConnectIT 365; an advanced integration suite for Dynamics 365 Business Central which can be used by both people with limited technical skills and by hardcore developers. 

Connectivity means productivity 

We already named a few, but here is a much longer list of examples of what can be done with ConnectIT. 

  • Import suppliers catalogues
  • Export product, price, inventory data for your retailers and other business partners
  • Real-time matching of customer and contact data between your favourite CRM and your Business Central system
  • Synchronise data between Business Central and systems like your warehouse (WMS) or transport (TMS) system
  • Periodic import of information from your HR and payroll systems
  • Integrate e-commerce solutions
  • Create detailed data feeds to link with online market places like Amazon and eBay
  • Inter-company - Synchronise sales data between Business Central companies or tenants
  • Master data management - Update subsidiaries who also run Business Central
  • Transport data from standard Business Central to an add-on solution or any third party application
  • Get information from and to your mobile services

    To accomplish tasks like the above you need to be able to fully customise your interfaces. That is exactly what you can do with ConnectIT. With any of these cases, ConnectIT is the toolkit that gets you the right results. Whether it is a simple CSV export, which can be created with just a few clicks, or you need a set of API calls with custom coding attached, ConnectIT is your friend. 

    Creating interfaces in the blink of an eye

    Traditionally, building an interface can be a time consuming and technically complex task. Not with ConnectIT. This solution elegantly guides you through the process. Even if you lack advanced technical knowledge! This saves you both time and money. Once your new interface is running, maintenance and monitoring are just as easy. Everything you need is available in this flexible and user-friendly toolbox.

    ConnectIT is completely embedded in Microsoft Dynamics 365 Business Central, so it can help you with even the most specific tasks. Again, just create the interfaces you need. 

    No coding required - Advanced coding possibilities

    Anyone can open up ConnectIT and create interfaces by just clicking buttons, selecting fields and adding settings on how the interface should behave. But, this wouldn't be a highly sophisticated integration studio if you couldn't go any further than that. So, if you are a developer and want to use AL code to add more logic, go ahead and write all the custom code units and functions you want. There is a huge list of events to which you can subscribe to validate, manipulate and parse data any way you like. You can also set up Azure functions or custom REST services which you can use within your import and export projects. All this makes that there are almost no limits to what you can do with ConnectIT. 

    ConnectIT 365 - Another smart Microsoft Dynamics 365 Business Central extension

    ConnectIT can be installed with just a few clicks and has a very low impact on your Business Central system. During the installation, you can also select to import a set of example interfaces. These samples are a great jump start for everyone new to ConnectIT, and who wants to start importing or exporting some direct right away. 

    For more information about ConnectIT, please contact us or one of our partners

    Here is what ConnectIT 365 does for you

    Export management features:

    • Export files in many formats like XML, CSV, JSON
    • Export to FTP/SFTP services, REST services, Azure Storage, Azure Service Bus, Azure Event Grid or Dropbox
    • Synchronise data between different companies or between Business Central tenants
    • Synchronise data between Business Central and any other system 
    • Detailed formatting of data
    • Add custom logic or both header and line level
    • Schedule your exports
    • Export based on record/field monitoring
    • Backup/Copy/Share export definitions

    Import management features:

    • Import files in many formats like XML, CSV, JSON
    • Import from FTP/SFTP services, REST services, Azure Storage, Azure Service Bus, Azure Event Grid or Dropbox
    • Generate import definition based on sample data
    • Automatic field mapping
    • Add custom logic or both header and line level
    • Validate data before importing
    • Schedule your exports
    • Import data based on record/field monitoring
    • Backup/Copy/Share import definitions

    Connector features: 

    • 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. 
    • 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

    Pre- and post-processing

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