Metadata import of MS SQLServer Tables

senthilkumarr · Post by **senthilkumarr** » Tue Jun 21, 2011 8:22 pm

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

ray.wurlod · Post by **ray.wurlod** » Tue Jun 21, 2011 8:41 pm

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.

senthilkumarr · Post by **senthilkumarr** » Wed Jun 22, 2011 2:36 am

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