Amazon RedShift

PGNP and 64-bit Client and/or Server; very large databases and LOBs; etc.

Amazon RedShift

Postby bobwhitley » Sat Mar 16, 2013 8:22 am

Does the OLEDB driver work with Amazon Web Service's RedShift data warehouse? I've tried connecting to it by creating a UDL with no luck. I can connect with ODBC, JDBC and the psql command prompt but can't get OLEDB to connect. Ideally I'd like to set up RedShift as a linked server in SQL 2012 but I can't even get it to work in a UDL file. Anyone one had any luck with this?
bobwhitley
 
Posts: 2
Joined: Wed Mar 13, 2013 12:34 pm

Re: Amazon RedShift

Postby Moderator » Tue Mar 19, 2013 10:54 pm

We did not test the PGNP provider with ResShift. If it is based on a Postgres clone, then most likely our product will work with it.
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm

Re: Amazon RedShift

Postby Moderator » Sun Jul 07, 2013 7:14 pm

We have completed development and testing of the OLEDB Provider for Redshift. Trial build is available on the Download page (http://www.pgoledb.com/index.php?option=com_filecabinet&view=files&id=1&Itemid=68).

The Provider uses Amazon S3 storage for fast loading of data into Redshift. Please refer to Developer's Manual for details.
User avatar
Moderator
Site Admin
 
Posts: 297
Joined: Wed Oct 29, 2008 11:27 pm


Return to 64-bit, Very Large Databases

Who is online

Users browsing this forum: No registered users and 1 guest

cron