Project Data Tranfer via Automation Interface.

[mariusz]

Is it possible to use Transfer Data Model (Oracle Repository to EAP ) via AI?
I have a very large project in Oracle Repository(EAP has about 0.5 GB!). Sometimes I have to generate eap file with some packages (it can be many packages, but not all). Now I generate xmi file (for root package), import it to local EAP, and in next step I remove needless packages(I wrote small Java App to automate it).

It is very uncomfortable and very time-consuming process (it takes me a few hours!)

Do you know more comfortable way to export some packages from very large repo to local eap via AI? I'd like to write Java App, to generate my project.

Thanks
mario

[Geert Bellekens]

On the Project interface there are operations to export and import xmi files.

So yes, should be entirely possible.

Geert

[Aaron B]

XMI Export and Import is available via the automation interface (Project.ExportPackageXMI and Project.ImportPackageXMI)

The Project Data Transfer feature (Tools | Data Management | Project Transfer) is not available via automation at this time.

[mariusz]

Thanks for your replies.

So is there any faster method to export many packages from EA repo than Export XMI?(via AI)

Best regards

[Geert Bellekens]

In theory you could write a program to query all details of the package and its elements, and recreate that into another model.

Sadly I think that is going to be a huge tedious job to write  :-/

Geert

[mariusz]

In theory you could write a program to query all details of the package and its elements, and recreate that into another model.

It could be a good idea, but is there any method to run SQL Update and Delete statements? (I have found only one method, which is only for SELECT statement)

[Geert Bellekens]

If you want to execute insert/update/delete statements you better create your own database connection in code.
There is an operation somewhere that will return the connectionString (or the path to the eap shortcut file that holds the connection string)

Geert

[mariusz]

If you want to execute insert/update/delete statements you better create your own database connection in code.
There is an operation somewhere that will return the connectionString (or the path to the eap shortcut file that holds the connection string)

Geert

But if it is possible to get a direct jdbc/odbc connection to local eap file ( because I need insert a lot of records from repo to local file - maybe it could be treat as a MS-Access DB file - but I haven't tested it)?


I'm still thinking about your proposal of recreation all Packages Elements, Diagrams itd. in local file. It is very interesting idea, but I have one more requirement. GUID all elements in my local file must be the same as Element GUIDs in remote Oracle Repo. Operation AddNew in Package/Element in my local file creates for my new Element with new GUID. This property is read only, so I can't copy it from old element to newly created.

[Geert Bellekens]

I really don't think this is a good idea.
Cost/Benefit wise the xmi import/export option will probably score a whole lot better, especially since you don't have the re-occuring maintenance costs that you face when writing it completely from scratch. (xmi export/import is kept up-to-date by Sparx)

Geert