Using Automation to Import DB Schema from ODBC

[Derek Poulin]

I'm trying to use automation to import our database schemas into EA, but I don't see how to do it. Does the automation API support this? Can someone please point me in the right direction?

Thanks,
Derek

[jkorman]

Create a class diagram
Right click for a context menu - select [Import DB schema from ODBC]
brings up a dialog where you need to select "stuff"

Works pretty well!

Jim

[Derek Poulin]

Clarification: I would like to do this programmatically, not manually. That is, 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:
            // ???
        }

Any ideas how to do this?

Thanks,
Derek

[«Midnight»]

I believe this is not possible, at least not yet.

This remains a significant omission in the EA feature set. I have no idea if Sparx is working on it; even if they are it might be a "future version" thing.

Perhaps you could request this feature. The more of us who do, the greater chance Sparx will recognize it as a priority.

To do so, follow the Feature Request link below the Support link near the bottom of any forum page.

David