Book a Demo

Author Topic: Programmatically Import DB Schema from ODBC  (Read 3367 times)

Derek Poulin

  • EA Novice
  • *
  • Posts: 3
  • Karma: +0/-0
    • View Profile
Programmatically Import DB Schema from ODBC
« 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