Welcome to MSDN Blogs Sign in | Join | Help

Attunity connectors for Oracle and Teradata are now available

The high speed connectors for Oracle and Teradata are now available for download.

  Supported versions Platforms
Oracle 9.2.0.4 or higher x86, x64, ia64
Teradata 2R6.0, 2R6.1, 2R6.2
and 12.0		 x86, x64

Attunity has done a great job putting these together, and from what I’ve seen, the performance is really impressive. Be sure to check them out!

Published Thursday, October 02, 2008 3:05 PM by mmasson
Filed under:

Comments

# New connectivity options in 2008

Update: 2008-08-13 - The connector pack will be available two to three months from the GA of SQL 2008

Thursday, October 02, 2008 6:09 PM by SSIS Team Blog

# re: Attunity connectors for Oracle and Teradata are now available

I have tried the Attunity connector for Oracle and the only good thing I can say is that the performance is pretty good.  I was disappointed with the features and the implementation from an architectural point of view.

First it seems to be lacking the ability to parameterise the queries on the Oracle Source component, have I missed something?  If this is the case then it is of no use to me.

Second from an architectural perspective I am not impressed by the way it is implemented as separate component.  It should be implemented as an additional provider to the standard OLE DB Source/Destination in the same way as the DataDirect driver is.   The way it has been implemented means that if we decide to change to use a different driver we have to modify all of our packages, whereas if it was implemented the DataDirect way we could design our packages so that we could implement such a change with simple config changes and no need to modify the packages.

Thursday, January 08, 2009 7:27 AM by ArthurHarper

# re: Attunity connectors for Oracle and Teradata are now available

Hi Arthur,

This is good feedback, and I've forwarded it along to the right people.

Comments like this are good for Connect (http://connect.microsoft.com/) as well.

Thanks!

~Matt

Thursday, January 08, 2009 3:28 PM by mmasson

# Anyone else having trouble with DATE fields?

First, I ran several tests with the Attunity connectors - and they did the best job of correctly recognizing the metadata from an oracle source (10g and 11g).  Speed was fantastic pulling from oracle and writing to SQL.  Writing to oracle seemed much much slower.

Second - what Arthur said.  

Third - has anyone else had a problem writing to oracle (with the Attunity Oracle Destination) with recognition of DT_DBTIMESTAMP fields?

Wednesday, January 14, 2009 3:33 PM by sgrimes

# re: Attunity connectors for Oracle and Teradata are now available

What problems are you seeing?

Wednesday, January 14, 2009 6:05 PM by mmasson

# re: Attunity connectors for Oracle and Teradata are now available

I've begun using the Oracle connector and it is definitely fast.  One issue I've run across is that a char field holding a space (' ') in SQL Server gets sent to Oracle as a NULL.  This is causing us some issues and I can't seem to find a way around it.

Friday, March 13, 2009 3:49 PM by brooksray

# re: Attunity connectors for Oracle and Teradata are now available

I have installed the attunity connector for oracle & i'm using a eval version of Sql Server 2008....i'm not able to use the attunity connector...any ideas how to go about?

Wednesday, June 03, 2009 3:06 PM by rojit@hotmail.com

# re: Attunity connectors for Oracle and Teradata are now available

What sort of error are you seeing?

Wednesday, June 03, 2009 3:54 PM by mmasson
Anonymous comments are disabled
 
Page view tracker