cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

PowerDesigner - ObjectSelection from DataSource

aseidel1
Discoverer
0 Likes
301

Hi,

these days I'm playing around a little with reverse engineering tables (in an Oracle DB) using VBScript in PowerDesigner. Based on the example in the MetaModel Help I use an ODBC data source in conjunction with the methods Model.ConnectToDatabase and adding a table owned by an owner using the method

model.AddToOdbcSelection odbcSelection, cls_Table, "", objName, objOwner

where objName is the table name and objOwner the tables owner. After setting some package options calling

model.ReverseDatabase ActiveDiagram 

the desired table gets successfully reverse engineered and its symbol is put on the active diagram. So far pretty straightforward an no problem.

My question now is, how can I get an object picker / object selection dialog listing all available tables read by the ODBC data source like it is shown when updating the model from database via the menu (Database -> Update Model from Database...)? I don't know why, but doing the reverse engineering with VBScript is much much faster than using the build in function from the menu.

Or besides that, how can I determine whether or not the given table which is added to the ODBC selection is successfully found end reverse engineered? Is there any possibility to access the ODBC selection content?

Thank you,

Andreas

Accepted Solutions (0)

Answers (0)