The BiZZdesign Connect functionality in Enterprise Studio supports exchanging model information between Enterprise Studio and external applications. Model data can be imported in Enterprise Studio and can be exported from the tool to the external data source. BiZZdesign Connect supports model data exchange with Microsoft Excel workbooks, ServiceNow tables, and SQL databases used by Microsoft SQL Server, MySQL and IBM DB2 (only tested for Windows, Linux is unknown).
Example of an Excel connection
The information exchange is based on a data connection that is created in Enterprise Studio. Mappings in the connection identify the relationships between model data in Enterprise Studio and the external data source. Depending on your needs, you can create multiple connections to exchange the desired model information.
Example of a ServiceNow connection
By repeatedly executing a data connection in some direction (import/export), data can be exchanged between Enterprise Studio and the external data source over and over again.
Example of an SQL connection
Prerequisites external applications
With the Excel connection data is exchanged with Excel files that are accessed using the installed Microsoft Excel application. If you do not have Excel installed, there is still the possibility to import and export Excel worksheets, but with a few limitations. For more information about this solution, see Import and export of Excel worksheets using an ADOdb connection.
With the ServiceNow connection data is exchanged with tables on the ServiceNow platform available in your organization. The connection makes use of the REST API of the ServiceNow platform to exchange data.
With the SQL connection data is exchanged with tables in an SQL database. The connection makes use of SQL queries to exchange data. Enterprise Studio uses an OLE DB or ODBC API to connect to an SQL database. For more information, see Required drivers for the SQL connection.
Supported modeling languages and methods
Information from the following models can be exchanged:
ArchiMate® is a registered trademark of The Open Group.