DSXchange

Can anyone suggest how to do metadata import of SQL Server Database tables.

Iam not seeing any option in manager for metadata import of SQL server.

Since I need to load metadata into ODBC enterpriise stage to extract the data

Welcome aboard.

You must have an ODBC connection to SQL Server - since SQL Server does not run on UNIX.

Then you can import using the ODBC Connector Import Wizard, or via the Orchestrate orchdbutil mechanism.

But the first thing you need to do is to configure the ODBC data source name on the UNIX machine. This requires entries in .odbc.ini and in uvodbc.config files.

Thanks Ray,ODBC Connection was made and i can able to do metadata import.