Attunity with SQL Server

Question

Hello everyone,

I just wonder if there's anyone who uses\used Attunity with their SQL Server
environment?

I would appreciate if you have any experience, suggestion or tips to share
with me.

Thanks.

---

Ekrem Önsoy - MCDBA, MCITP:DBA & DBD, MCSD.Net, SQL Server MVP

Answer 1

Hi,

In SQL Server 2008 Integration Services, you could use Microsoft Connectors for Oracle and Teradata by Attunity. For more information, please refer to:
Using the Microsoft Connector for Oracle by Attunity with SQL Server 2008 Integration Services
http://msdn.microsoft.com/en-us/library/ee470675.aspx
Microsoft Connector for Teradata by Attunity
http://msdn.microsoft.com/en-us/library/ee692365.aspx

If you have any more question about Attunity, you could go to  the SQL Server Integration Services forum:
http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/threads

If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 2

Actually I was interested in Attunity in terms of Change Data Capture. Two days ago, they performed a demo via Net Meeting and it certainly does not meet our requirements.

Actually, yesterday I already posted an article to my web site about these cons and the differences between Attunity and Oracle Golden Gate.

The main con that we can not tolerate is that Attunity can not read from Transaction Log backup files for replication but it only read from the Transaction Log file itself just like SQL Server Replication and in case of a problem or delay, it causes the Transaction Log file to grow and make the database unusable when the disk or t-log file is full. However Oracle Golden Gate reads from the Transaction Log backup files. We are already using Oracle Golden Gate product on our prod servers for replication to feed our remote servers for fraud detection, however Oracle Golden Gate still does not support SQL Server 2008 as the source database and it's a blocker for our upgrade plan so we are looking for alternatives which can compete against Oracle Golden Gate's advantages.

Thanks for your interest.

---

Ekrem Önsoy - MCDBA, MCITP:DBA & DBD, MCSD.Net, SQL Server MVP

Answer 3

Hi,

Actually, Attunity Oracle-CDC for SSIS is available from Attunity.  Information is available at  http://www.attunity.com/oracle_cdc_for_ssis. If you have any suggestion about it, I suggest you go to Attunity Serivce & Support:
http://www.attunity.com/services_and_support_overview

 
If there are any more questions, please let me know.
Thanks.

---

***Xiao Min Tan***Microsoft Online Community***

Answer 4

In Microsoft SQL Server 2012 there is Change Data Capture for Oracle by Attunity included on the DVD.

I have started this wiki page to help explain how to find and install the features.

http://social.technet.microsoft.com/wiki/contents/articles/7644.microsoft-sql-server-2012-change-data-capture-for-oracle-by-attunity-topics.aspx

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 5

Jason,

How much do you know about formatting the Connection string for this connector?  We are going to use the Oracle Wallet for storing id and password.  But I can't seem to figure out how this connection resolve that? 

Answer 6

I'm not sure...

Reading about Oracle Wallet here just to get a feel for it. Did you try it yet - by giving the database @alias without a user name and password?

http://docs.oracle.com/cd/B28359_01/java.111/b31224/clntsec.htm

Secure External Password Store
As an alternative for large-scale deployments where applications use password credentials to connect to databases, it is possible to store such credentials in a client-side Oracle wallet. An Oracle wallet is a secure software container that is used to store authentication and signing credentials.

Storing database password credentials in a client-side Oracle wallet eliminates the need to embed user names and passwords in application code, batch jobs, or scripts. This reduces the risk of exposing passwords in the clear in scripts and application code, and simplifies maintenance because you need not change your code each time user names and passwords change. In addition, not having to change application code also makes it easier to enforce password management policies for these user accounts.

When you configure a client to use the external password store, applications can use the following syntax to connect to databases that use password authentication:

CONNECT /@database_alias
Note that you need not specify database login credentials in this CONNECT statement. Instead your system looks for database login credentials in the client wallet.

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance

Answer 7

Looks like the folks at Attunity got the Oracle Wallet to work... read the thread here:

http://www.attunity.com/forums/attunity-oracle-cdc-ssis/oracle-connection-string-msora-1942.html

---

Didn't get enough help here? Submit a case with the Microsoft Customer Support team for deeper investigation - http://support.microsoft.com/select/default.aspx?target=assistance