topic Re: How to establish a SAS Metadata Bridge between SAS EG 7.1 and Sybase PowerDesigner in SAS Enterprise Guide

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

alepage — Thu, 02 Aug 2018 18:38:37 GMT

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

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

SASKiwi — Thu, 02 Aug 2018 23:01:54 GMT

What would be the purpose of this bridge?

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

LinusH — Fri, 03 Aug 2018 06:07:10 GMT

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.

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

alepage — Mon, 13 Aug 2018 13:31:10 GMT

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,

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

SASKiwi — Tue, 14 Aug 2018 08:19:18 GMT

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.