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