Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: shimon on March 24, 2014, 07:10:38 pm

Title: Adding Data Source via script for all new users
Post by: shimon on March 24, 2014, 07:10:38 pm

Hi,
Im planning a migration from one DB to another (SQl to Oracle) and would like to give each user an easy way to add the Data Source.
Does anyone have a VB (or other) script, that adds a Data Source to EA?

Thanks,
Shimon J.

Title: Re: Adding Data Source via script for all new user
Post by: shimon on March 24, 2014, 07:27:12 pm

OK.
Just found this and it should work if the users have the "Right" to add a key to the registry.
I'll update this post if it works.

http://windowsitpro.com/systems-management/how-do-i-migrate-odbc-data-sources-one-server-another

Title: Re: Adding Data Source via script for all new user
Post by: Mauricio Moya (Arquesoft) on March 27, 2014, 09:03:19 am

You can create a connection to the Oracle server without having an ODBC declared in the Windows ODBC sources. This could be done when connecting to a database in EA. After doing that (and typing the server, username and password for the database) you can create a shortcut from "File/Save shortcut" and distribute the shortcut.