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

5 pts.
Tags:
64 bit architecture
Data warehouse
ETL
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?
ASKED: May 21, 2008  4:35 PM
UPDATED: May 21, 2008  6:32 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

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.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following