Sparx Systems Forum

Enterprise Architect => Suggestions and Requests => Topic started by: Derek Poulin on September 17, 2008, 09:32:55 am

Title: Programmatically Import DB Schema from ODBC
Post by: Derek Poulin on September 17, 2008, 09:32:55 am

I would like to use automation to programmatically (not manually) import our database schemas into EA, but I don't see how to do it.

I want to create a Windows console application that calls into the EA automation API:

       static void Main(string[] args)
       {
           // Get app settings:
           string project = ConfigurationManager.AppSettings["Project"];

           // Open EA:
           EA.Repository repository = new EA.RepositoryClass();

           // Open the project specified in the app's configuration file:
           repository.OpenFile(project);

           // Do the Import DB Schema from ODBC:
           // ???
       }

Can this be added to the Automation API? Is there another way to do this? We have 100+ schemas that we would like to import and keep up to date via scheduled imports/refreshes.

Thanks,
Derek