Using Attunity Connectors to connect to Oracle

• treyagrimes

  Ten Centuries

  Points: 1001

  More actions

  April 20, 2015 at 4:27 pm

  #303060

  Hello,

  I am hoping someone may be able to assist me in troubleshooting why the Attunity connectors are not appearing in my connection manager in SSIS.

  I am running Windows 7 SP1 (64-bit), Visual Studio 2013 Business Intelligence, SQL 2012 Enterprise Edition (64-bit).

  I have installed the Attunity drivers - 64 bit version:

  

  But when I try to connect to an Oracle database, there is no option in either the connection manager nor the data flow task under other sources.

  I have the 32-bit Oracle client installed along with PL/SQL and I am able to connect to the database; and the TSNAMES file has already been configured and pointing to the right databases.

  I just don't see the option with VS 2013 to connect. What am I doing wrong? Please advise.

  Thanks,

• Martin Schoombee

  SSCoach

  Points: 19135

  More actions

  April 20, 2015 at 4:35 pm

  #1792248

  You'll need to manually add the components in VS, see the thread here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/9a362710-1cfa-41f0-a7e1-54fdaed9123c/attunity-option-not-showing?forum=sqlintegrationservices

  Also note that the designer of SSIS runs in 32-bit mode, so you will have to install the 32-bit versions of the driver as well.

• treyagrimes

  Ten Centuries

  Points: 1001

  More actions

  April 20, 2015 at 5:15 pm

  #1792250

  Hey Martin,

  According to Attunity's documentation, a 64-bit connector installs both the X86 (32-bit) and X64 (64-bit) DLLS.

  Unfortunately, I cannot manually add the items. Looks like this feature might have been removed in VS 2013:

  This worked before I did a fresh install of Windows on my machine and re-installed all programs. But now I don't see the Oracle connection in either place I saw them before:

  

  or

  

• Martin Schoombee

  SSCoach

  Points: 19135

  More actions

  April 21, 2015 at 10:17 am

  #1792473

  Go to Tools >> Choose Toolbox Items >> COM Components

  The Attunity connectors should be in that list for you to add. If not, you may have to manually register the dll's.

• treyagrimes

  Ten Centuries

  Points: 1001

  More actions

  April 21, 2015 at 11:11 am

  #1792505

  Hey Martin,

  I don't see them listed under COM but if I open SQL Sever Data Tools (using Visual Studio 2010 Shell) - the Attunity connectors are there and I can connect to an Oracle database.

  This seems to be isolated to Visual Studio 2013 in my case.

  Thanks,

• treyagrimes

  Ten Centuries

  Points: 1001

  More actions

  April 21, 2015 at 1:04 pm

  #1792547

  Hey Martin,

  Turns out I need the SQL 2014 connectors:

  And it works.

  Thanks for your help however.