It can be a mammoth task to manage all your isolated business systems if they are not currently connected to your ERP. Additionally, streamlining operations and making impactful business decisions is challenging if you do not have an integration platform connecting all your data from your ERP to the business systems. And if you’re relying on your IT team to work on this, it means a lot of development, time, and effort that could probably be spent on other critical tasks.
At To-Increase, we understand these challenges as we have been developing value-added solutions for Microsoft for the last 17 years. To ensure data synchronization, data mapping, and data migration between the ERP and business systems, we have developed an integration solution that is built within the Microsoft D365 environment to help our customers truly achieve data transformation.
If you are looking to integrate your Microsoft Dynamics 365 ERP with your business systems, then Connectivity Studio might just be the tool you are looking for. In this blog, we share the features, benefits, limitations, pricing, and other details that will help you determine whether Connectivity Studio is the right integration platform for your business or not.
One important thing to note: Although To-Increase offers the solution for Dynamics 365 FO, D365 BC, AX and NAV, in this blog we will be focusing on the D365 version.
What is Connectivity Studio?
Connectivity Studio is an advanced data migration, mapping, and integration tool focused 100 percent on configuration and built inside Microsoft’s D365 ERP. The solution simplifies the setup and management of integrations between your ERP and other business systems.
Connectivity Studio helps migrate your data from any legacy system - including Microsoft Dynamics 2009, and 2012 - to Dynamics 365 for Operations.
Connectivity Studio integrates with a wide variety of systems, including different formats and protocols.
Examples of integration scenarios of existing customers:
- integration with mobile field-service solutions
- syncing of data across eCommerce and multi-channel retail
- integration with PLM systems
- managing the interactions and updates between the back office and retail location
- EAI integration with Dell Boomi
It is important to note that technical integrations can be implemented by various means. Some examples below:
- Microsoft Dynamics 365 for Operations database
- file system (folders)
- web services
- data connection with ODBC
What are some of the features of Connectivity Studio?
Configuration-based: With Connectivity Studio, your IT team can create integrations from and to D365 by configuration and not development. By using the standardized configuration, your integrations will go quickly and smoothly.
Tables, views, and entities: Connectivity Studio allows you to use tables, views, entities, or a combination of all to configure integrations. This adds a lot of flexibility to configure your integrations.
Demo of the mapping feature for Connectivity Studio
Field mapping: Connectivity Studio offers a form mapping function. The user has to select the exact corresponding field on a form for the original input fields for the integration on the form. Once done, the mapping is created.
Staging tables: For any kind of changes to data or corrections, incoming data can be stored in a staging table prior to import. The data can be edited or validated in the staging area before processing.
Event log: In case of any changes, an event log can be applied for each connection. The database triggers enable the log to detect insertions, deletions, modifications, and renaming. And the solution will synchronize just the changes in data.
Demo of the event trigger feature
Data records: The system logs all data exchanges in the message history for every integration, so this also makes data reporting easier.
Support for several document formats: The document formats supported include Delimiter-based (CSV), flat file, fixed text, ODBC using the Azure Service Bus, Microsoft Excel, Microsoft Word, EDI, and XML file (with XSD or XSLT). Additionally, custom formats can be used to meet specific formats.
Document actions: Perform a variety of actions on integration documents, such as pre-processing, exchange, and post-processing steps. Standard available actions include email, compression, conversion, copy/move, send/receive, and Azure Blob storage, and SFTP.
Business logic: When you integrate your systems with Connectivity Studio, validations, and defaults on selections are made automatically thanks to the platform’s business logic rules. This is a major value-add for your EDI or electronic data interchange documents exchanged.
Tutorials: Besides the workshop and training provided by our delivery team, we do have tutorials within the software to help you get started.
What are the benefits of Connectivity Studio?
Easy to use
With Connectivity Studio you can make integrations in a synchronous and asynchronous way. These integrations can be configured without the need for any coding or development and can be done in-house.
To tackle the difficulty of being unable to use any field or any table in the data entities provided by Microsoft, To-Increase developed Connectivity Studio. As our solution is able to use any table, view, and data entities in D365 F&O, you can configure the most complex integrations. For example, the mapping of your trading partners for EDI communication as well. To-Increase also offers solutions for EDI (EDI Studio) bundled with Connectivity Studio.
Works with upgrades
If Microsoft adds or updates a functionality, then there is no need for development. As our solution offers you the flexibility to use (custom) tables, or a combination of multiple standard tables for integrations even with the new upgrades to data entities, without any stress of development.
Data segregation is possible
With Dynamic 365 you can maintain different ledger accounts separately, also known as companies, into one system. Segregating this data can be a challenging task during an integration. In a data migration scenario, you would need to import data into multiple companies at the same time. Connectivity Studio can help you import data into multiple companies simultaneously using a mapping specific to each company.
Manage multiple data scenarios and more
You might have different data fields in different business systems. During integrations and data transfers, using Connectivity Studio, you can make changes on the go. For each field mapping, you can set up constants, defaults, conversions, and transformations to ensure smooth integration and data synchronization between business systems.
Seamless data syncing
Connectivity Studio is the engine that transfers data in and out of Dynamics 365 F&O. With our solution, using synchronous and asynchronous communication transfer, you can import and sync large amounts of data in near-real-time.
What are the limitations of Connectivity Studio?
Integrated with single ERP
Since we are built within Microsoft D365, Connectivity Studio cannot be configured for the integration of any other ERP and business systems. We are soon expanding beyond D365 F&O though. So, keep a lookout for that.
There are direct connections possible to other ERPs/business systems, for example: via ODBC, web services, or other options.
No standard integrations
To-Increase offers tutorials so that our customers can quickly get started with configuration. However, currently, we do not have any standard templates as we do for EDI communication in our EDI Studio solution.
Large data exports
Currently, Connectivity Studio does not offer large data exports, but we offer a solution that can help you with large data exports – Data Modeling Studio (DMS). DMS can perform exports or incremental exports and you can use it to also create tables in BYOD (bring your own database).
Currently, we do not offer local file import support. However, we use other methods to share files such as Sharepoint interfacing.
How much does Connectivity Studio cost?
We follow a waterfall pricing model for the annual licensing fees for our BIS solutions. Our solutions are priced per company, per month. So, if you are looking at a multi-company integration scenario, the cost works out better.
The price for Connectivity Studio works out to €1065* per month, per company, if it is just one company. If your requirement ranges for more than 1 company, the solution cost drops significantly for the 2nd company at €210* per company, per month. Which works out €1275* per month for both companies.
Additionally, if you are also interested in another BIS solution, such as EDI Studio or MDM Studio then the cost per company, per month for a single company for two solutions would be €1360* and €1650* for all three solutions per company, per month.
Other than annual licensing, you will also be looking at training and implementation costs. We offer 1 day of training and 3 days of workshops for most of our customers.
* Please contact us for dollar pricing
Is Connectivity Studio the right integration platform for you?
Connectivity Studio would be a good fit for you if, you are looking for a versatile solution that can not only help you integrate your ERP and business systems but can also manage data mapping and data migration. It is a configuration-based, DIY solution, so you do need your IT team to manage the platform and configure integrations. However, if you are looking at standard integrations inside the tool, then Connectivity Studio would not be the best fit for your organization.
If you want more information on Connectivity Studio you could download our factsheet. If you are also interested in any of our BIS solutions, you can read our review on our Electronic Data Interchange (EDI) solution or download our Master Data Management factsheet.
If you have any unanswered questions or are interested in learning more about Connectivity Studio, go ahead and reach out to our experts. They can guide you and help you with best-case business scenarios based on your current business setup and requirements.