How can I export the data from IBM Universe to MS-SQL

*** Hopeleonie ***
*** Hopeleonie *** used Ask the Experts™
on
Hi

I have asked a question before. Please have a look:
http://www.experts-exchange.com/Database/Miscellaneous/Q_27721987.html

Now I need to export data from IBM Universe to MS-SQL. Can somebody tell me step by step how to do this?

Thank you so much
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
lcohanDatabase Analyst
Commented:
You can install IBM UniVerse ODBC Driver on the SQL server
Configure a ODBC System DSN data source
Create a Linked Server in SQL by using that data source
Run queries in SQL against IBM db and transfer data

Please see some other info to help you getting connected at:
http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/240df5b1-d069-48ed-92a6-aeca6053ce65/
http://social.msdn.microsoft.com/Forums/en/sqlintegrationservices/thread/3c0eb057-8a77-4dc6-9630-d6e6abe19fcc
*** Hopeleonie ***IT Manager

Author

Commented:
Thanks give me some time to test this.
We use CloverETL, simple and easy to use -- check it out!
*** Hopeleonie ***IT Manager

Author

Commented:
Many thanks lcohan & MikeOM_DBA

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial