Sparx Systems Forum
Enterprise Architect => General Board => Topic started by: PeterHeintz on March 27, 2024, 07:51:53 pm
-
I intend to write some powerpoint scrits to fiddle arount with qea repositories.
I assumend that "SQLite.dll" is in the EA installation but I do not find it.
Can anyone point my to the dll or say me how EA accesses SQLLite repositories internally.
-
You normally don't need direct database access.
Best practice is to use the API.
If you need to do an SQL Query, you can use the operation Repository.SQLQuery
That works on any backend (as long as your syntax is compatible)
Geert
-
We have used a SQLite3 driver to connect to a QEA(X) repository file for PowerBI.
Check posts "https://sparxsystems.com/forums/smf/index.php/topic,47929.msg278885.html#msg278885 (https://sparxsystems.com/forums/smf/index.php/topic,47929.msg278885.html#msg278885)" and "https://sparxsystems.com/forums/smf/index.php/topic,47599.msg277436.html#msg277436 (https://sparxsystems.com/forums/smf/index.php/topic,47599.msg277436.html#msg277436)".
-
sqlite.org has an excellent introduction to CLI scripting. You download the SQLite CLI and call it via your terminal, command prompt or whatever. It works really well.
-
I assume that there is already something included in the EA installation and when using this, I have no need to take care that something addtional needs to be installed for may users.
Of couse the API can be used and I do that, but some things are just not possible with the API.
-
I assume that there is already something included in the EA installation and when using this, I have no need to take care that something addtional needs to be installed for may users.
Of couse the API can be used and I do that, but some things are just not possible with the API.
Most things are possible with the API, if you know the secret backdoor Repository.Execute()
Geert
-
If you want to use the EA API, the EA client has to be running to provide the access to it.
Can imagine situations when this is not the case, especially when one wnats to run a script unattended.
Be aware however not to mess up the database integrity...
-
If you want to use the EA API, the EA client has to be running to provide the access to it.
You can also start the EA client from your script/program, but there is indeed the complication that you need to run whatever automated process in a user context, with a valid EA license.
That is definitely more complicated than running an unattended service on a server.
Geert
-
Yes I start EA already in my scipts.
Is there e.g. a back door to disable security? Did e.g. not find a API method for that an therefore my script just deletes the relevant record via SQL.
-
Just delete the contents of t_secpolicies and EA will start without security. There are a couple of threads here on the forum dealing with that topic.
q.