Displaying items by tag: native xml
EAPostgresImportfromNativeXML: Enterprise Architect Native XML import to PostgreSQL solution
About Enterprise Architect Native XML Project Transfer
Native XML Project Transfer is a feature introduced in Enterprise Architect 15.1. Until then a full project could be transferred via Enterprise Architect Project Transfer between databases (from and to a local EAP file and/or a DBMS).
Enterprise Architect Native XML involves a two-step process:
- Export the source project: generated in the selected target folder, XML files match each Enterprise Architect DB table (e.g. t_attribute, t_object) and contain data in the XML format.
- Import the XML files and overwrite the target project.
Important: Native XML is different from the XMI import/export since it supports the entire project data, whereas the XMI only exports the model information (e.g. packages, elements, and diagrams) to be exchanged between EA projects or with other modelling tools.
Native XML advantages:
- Compared with the Project Transfer function, a connection to the source and/or target database is no longer needed.
- This is convenient to load a project on a Cloud-hosted project (e.g. in AWS or Ms Azure) by transferring files and run an import.
- Available on an http/https “Cloud Connection” via the Pro Cloud Server.
- Provides a convenient full backup function.
- Unnecessary data can be easily removed by deleting the XML file(s) matching a table (e.g. t_document.xml).
Description
EAPostgresImportfromNativeXML is a specific third-party solution for Sparx Systems Enterprise Architect modelling tool.
Goals:
- Import a Native XML into a PostgreSQL database from a command-line prompt or via a CMD batch file, instead of opening Enterprise Architect.
- Deliver better performances with a reduced execution time, especially relevant for very large model repositories.
This solution can be useful for a publication process involving transferring the work model repository to a publication database, dedicated for end users via Prolaborate; a batch file can be configured in this case with Windows Task Scheduler to run the transfer on a nightly basis.
You can contact me via email (guillaume [at] umlchannel.com) to obtain a copy of EAPostgresImportfromNativeXML.
Notes:
- Requires .NET Core 3.1 or greater.
- If it is not installed yet, you need to download Microsoft NET Core 3.1 Runtime Windows x64 Installer (or greater) from the following link: dotnet.microsoft.com/download
- This project uses Npgsql C# library (www.npgsql.org).
- The target PostgreSQL database must have an existing Enterprise Architect Project i.e. the SQL scripts available from Sparx Systems must have been run and an initial project loaded.
Initial Setup Instructions
- Extract the zip file e.g. in C:\EAProjectTransfer.
- Open the source EA project and run the Native XML Export (Configure > Transfer menu) to a target folder.
- Example with C:\EAProjectTransfer\nativeXML:
- Result for Sparx Systems "EAExample" project:
- Create a text file with details of the target Postgres database.
- An Enterprise Architect repository must be running on this Postgres database.
- WARNING: ALL THE DATA WILL BE DELETED ON THE TARGET DATABASE BEFORE RUNNING THE TRANSFER.
- The text file must contain the following details, separated by semi-colons:
- Database server IP address or name;
- Postgres Port number;
- Database name;
- Username;
- Password;
- Example
- Create dbdetails.txt text file in C:\EAProjectTransfer folder with the following content: localhost;5432;test_db;postgres;admin
Running the Native XML to Postgres EA database full project transfer
- Open the command line prompt (cmd).
- Go to the active folder e.g. cd C:\EAProjectTransfer.
- Run dotnet –version to check if .NET Core is installed.
- Running dotnet EAPostgresImportfromNativeXML.dll will display the following instructions.
- EAPostgresImportfromNativeXML tool takes 2 or 3 parameters:
- Parameter 1: full path to the text file that contains the database details (see previous instructions).
- e.g. C:\EAProjectTransfer\dbdetails.txt.
- Paramètre 2: path to the folder with the Native XML files generated by Enterprise Architect.
- e.g. "C:\EAProjectTransfer\nativeXML"
- Optional parameter 3: when the value skipwarning is provided, it skips the warning prompt before clearing data from the target Postgres database.
- Parameter 1: full path to the text file that contains the database details (see previous instructions).
- Example to run the import to a target database as per the dbdetails.txt file and using XML files from C:\EAProjectTransfer\nativeXML:
- dotnet EAPostgresImportfromNativeXML.dll C:\EAProjectTransfer\dbdetails.txt C:\EAProjectTransfer\nativeXML
- An executable file is also available:
- EAPostgresImportfromNativeXML.exe C:\EAProjectTransfer\dbdetails.txt "C:\EAProjectTransfer\nativeXML"
- Here is an illustration of the main steps executed by EAPostgresImportfromNativeXML.
- Parameters and the db details file content are checked.
- A connection with the Postgres database is established.
- If the database is missing one or several Enterprise Architect tables such as t_object, an error message displays all the missing tables.
- When all the native XML files are processed, the number of resulting INSERT queries is shown (no query has yet been executed on the target DB).
- Press "Enter" to confirm DELETING ALL DATA from the target DB Enterprise Architect tables and load the data from the XML files.
- Note this step is skipped when skipwarning parameter is provided.
- Data is deleted from each Enterprise Architect table (e.g. DELETE from t_object, etc.).
- The INSERT queries are executed to populate the database.
- Finally, the elapsed time in milliseconds is displayed and the project can be opened using the target database.
- Transferring the "EAExample" project to a local Postgres DB took 40 seconds (note: it includes the time to confirm the prompt message).
Contact: guillaume [at] umlchannel.com.