Posted by
Take Attunity Replicate for a Test Drive Today! There’s never been an easier way to experience the award-winning Attunity Replicate than with a test drive. This no risk experience is totally free to use and launches a pre-configured environment running in the cloud. There’s no software to download or install. It couldn’t be simpler.
Hello, I've taken over an new/existing system, a lot (all) of the hundreds of SSIS packages were built around using the MSTERA 32 bit ODBC (MS for Teradata by Attunity ODBC Driver) and data connector built using that in VS15 SSDT/4. Our entire system is everything 64 bit including source connections, so I can only guess the wrong d/l was pulled down early on and they rolled with it not knowing. Now we have the need to boost the data transfer throughput to reduce overall processing time of our cubes. The MSTERA 64 bit is also installed on the server, and I can nav to it's location on the server. I can see in the systems good ole ODBC Data Sources 32 and 64 bit, the drivers, etc but not the one(s) for Attunity/Terdata. I can see in SQL Server by way of dissecting the job, as well as in VS in the connection manager, where the MSTERA 32 bit driver is being used. My question, what tool on the server do I manage to get the MS for Teradata by Attunity 64 Bit to be installed or available in the ODBC 64 drivers to select from, so that in the VS Connector manager I can select the 64 bit driver, and build and deploy my SSIS packages to use 64 bit? (System Platform: Windows Server 2012 R2 Standard / SQL Server 2016 SP1 EE, SSIS, SSAS Tab, SSRS and TFS with VS15 as designing tool) Thank you Data_Geek
I'm working on modifying an SSIS package that includes several lookup transformations. In my experience you must have an OLEDB connection created to use a lookup. I am being asked to change the lookup to connect to a Teradata connection. We have installed the Attunity drivers and Teradata is an option under ADO.NET connections but not under native oledb connections. For reference I see the native oledb for Oracle. How do I create a connection to Teradata that I can use in a lookup or an ole db command?
Attunity Teradata Driver Free
Attunity Teradata Driver Update
2 Answers
For 2008+, you have two options for a Lookup Component. The first is to use an OLE DB Connection Manager. For all other Connection Manager types, use a Cache Connection Manager
Add a Data Flow, I usually call mine 'Warm Cache' where you use your source, an ADO.NET Source and route it to a Cache Transformation destination. When your package begins, it will dump all the data to the CCM.
Attunity Drivers For Teradata
Then, in your 'actual' data flow, change the Connection type to reference the Cache you populated in the previous step.
billinkcbillinkcAs for the Teradata driver, you can download the OLEDB driver from Teradata, available here
AndrewAndrew