Desktop productivity for business analysts and programmers

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

Reply
Regular Contributor
Posts: 172

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

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

 

Super User
Posts: 4,034

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

What would be the purpose of this bridge?

Regular Contributor
Posts: 172

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

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,

 

Super User
Posts: 4,034

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

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.

Super User
Posts: 5,922

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

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.
Data never sleeps
Ask a Question
Discussion stats
  • 4 replies
  • 109 views
  • 0 likes
  • 3 in conversation