Home > IT Answers > DataCenter > Retrieve data (ETL) from 32 bit architecture ...
Help

Question

Asked:
Asked By:
May 21 2008   4:35 PM GMT
Jmc   5 pts.

Retrieve data (ETL) from 32 bit architecture to a data warehouse running 64 bit


64 bit architecture, ETL, Data warehouse, SQL Server 2005 (64-bit)

The proposed data warehouse platform will be a 64 bit platform - both OS and SQL2K5. Will there be any issues with drivers or anything else you can think of as I'll be pulling data (ETL processes will reside on the 64 bit platform) from multiple databases on 32 bit OS and SQL2K5 platforms?

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: May 21 2008  6:31 PM GMT  by Mrdenny   41270 pts.




If you are pulling from only SQL 2005 servers then there will be no problems at all. If you need to be able to pull data from other platforms which Microsoft doesn't provide drivers for (such as Oracle) you will need to provide 64bit drivers for the source systems.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on DataCenter, DataManagement and SQL Server.

Looking for relevant DataCenter Whitepapers? Visit the SearchDataCenter.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mrdenny   41270 pts.  |   May 21 2008  6:32PM GMT

Check out my SQL Server blog “SQL Server with Mr Denny” for more SQL Server information.