Syndeia and MySQL

S1

Connect to one or more MySQL repositories 
Connect to one or more MySQL repositories (servers) in your organization by supplying the URL and your credentials.

S2

View contents of MySQL repositories 
View the contents of a MySQL repository, such as databases, tables, and rows, in the Syndeia Dashboard.

S3

Search MySQL repositories
Search for data in MySQL repositories using an easy-to-use query builder or directly entering MySQL queries from the Syndeia Dashboard.

S4

Create Reference connections between SysML model elements and MySQL elements 
Drag-n-drop artifacts from any repository/tool to a database / table / row in a MySQL repository, or vice versa, to create a reference connection. A reference connection is the most basic form of traceability between artifacts and data managed in a MySQL repository.

S5

Generate MySQL tables from SysML blocks 
Drag-n-drop a SysML block to a MySQL database element to create a table. This also creates a connection between the block and MySQL table that can be used for compare and bi-directional sync operations.

S6

Generate MySQL table rows from SysML block instances / specialized blocks 
Drag-n-drop instances / specializations of a SysML block connected to a MySQL table to generate rows in that table. This also creates connections between the block instances / specialized blocks and MySQL table rows that can be used for compare and bi-directional sync operations.

S7

Generate SysML blocks from MySQL tables 
Drag-n-drop MySQL tables to a SysML package to generate SysML blocks corresponding to the table. This also creates connections between the MySQL tables and SysML blocks that can be used for compare and bi-directional sync operations.

S8

Generate SysML block instances / specialized blocks from MySQL table rows 
Drag-n-drop MySQL table rows to a SysML package to generate SysML instances / specializations of the block connected to the table. This also creates connections between the MySQL table rows and SysML block instances / specialized blocks that can be used for compare and bi-directional sync operations.

S9

Compare SysML block instances / specialized blocks and Excel table rows 
Invoke the Compare operation on connections between SysML block instances / specialized blocks and MySQL table rows to generate a difference table that shows the specific values that are in-sync and out-of-sync between SysML elements and table rows.

S10

Sync SysML block instances / specialized blocks → MySQL table rows 
Invoke the Sync SysML → Target operation on connections to compare and push values from SysML instances / specialized blocks to MySQL table rows.

S11

Sync MySQL table rows → SysML block instance / specialized blocks 
Invoke the Sync Target → SysML operation on connections to compare and push values from MySQL table rows to SysML instances / specialized blocks.