How to establish a SAS Metadata Bridge between SAS EG 7.1 and Sybase PowerDesigner

[alepage]

Hello,

Does someone has already establish a bridge between SAS EG 7..1 and Sybase Power design

and if so could you provide a sample code.

Thanks

[SASKiwi]

What would be the purpose of this bridge?

[alepage]

Hello,

the purpose of the bridge will be to load / read a DDL file directly which could be use to generate a SAS Template ( SAS data set with no data)

Regards,

[SASKiwi]

So you want to use Sybase PowerDesigner to automatically create an empty SAS dataset? If so it is completely the wrong tool for the job. The architecture of a (Sybase) relational database and SAS datasets is so different that even if there were a metadata bridge (i don't think there is) I think it would be doomed to failure.

[LinusH]

I don't think that the bridge is driven by, or even touches EG. It's a metadata server interface.
Of course you can in some situations explore imported metadata objects from EG.
But typically that doesn't make sense until you have populated the table structures with actual data. A task that is generally performed by Data Integration Studio.