Importing Oracle DB Schema

[David Goshadze]

Hi All!

I am importing oracle database schema using oracle 10.2.0.4 oracle instant client ODBC driver.
Import works fine, but there are no procedures imported as operations from oracle user packages. Oracle package is imported as Class with stereotype "package". And only two operations are defined in that class: body() and specification().

However if function or procedure is at schema-level and not package level, it is imported as an operation.

Is there a way to import oracle package level procedures and functions?

[David Goshadze]

I just received notification email, that someone had posted reply, but I can't see one. Do I miss something? Is there any special place to look for replies(Ridiculous, asking just for case)

[Eve]

It's possible someone replied then deleted their reply.

[RoyC]

Your reply was from a spammer, and - unfortunately - had nothing to do with your question. The spam was deleted.

[David Goshadze]

Thanks Roy, Simon.

It seems that noone had run into this issue.

I'm new to EA and I'm only evaluatiing this product.
Maybe gurus can point me to possibilities to find workaround.
Can I write my own script/plugin for importing DB schema.
Could anyone please point me to docs/examples.

Thank you in advance.
Regards,
David.

[Geert Bellekens]

David,

You can definitely write your own script/addin, but it won't be a small task.
It's not like you can just edit the existing import script since that is not publically available.

If I were you I would work with what's already there, send in a feature request for what's missing, and maybe write an addin to import the missing parts only (while waiting for the new feature to be implemented)

Geert

[David Goshadze]

Hi Geert and thanks for your answer.

I could live with an add-in for importing packages only.

I have quite a good expirience with VBScript, JScript. As well as I am fully capable of writing C#/C++ application or module. I just need good docs/examples.

David.

[Geert Bellekens]

David,

There are a couple of source for examples.
I believe there are a couple of example addins/scripts supplied with the installation (look in "EA installation folder/Code Samples" and "EA installation folder/Scripts")
Next there are some examples to be downloaded from the website
Then there are also some examples you can download from the community site
You could use the Excel importer (VBA) as an example of how to add stuff (classes/attributes and tagged values, but you can apply the same principle to operations) and the Navigator addin (C#) as an example for a C# addin.

Geert

[David Goshadze]

Thanks, Geert.

David.