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
Metadata import of MS SQLServer Tables
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Sat Jun 18, 2011 11:18 am
- Location: Chennai,India
Metadata import of MS SQLServer Tables
senthil kumarr
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 6
- Joined: Sat Jun 18, 2011 11:18 am
- Location: Chennai,India