InfoQ

InfoQ

InfoQ

En | 中文 | 日本語 | Br

562,907 Jan unique visitors

News

My Bookmarks

Login or Register to enable bookmarks for unlimited time.

The content has been bookmarked!

There was an error bookmarking this content! Please retry.

SSIS for Oracle and Teradata

Posted by Jonathan Allen on Oct 10, 2008

Sections
Architecture & Design,
Development,
Operations & Infrastructure
Topics
Interop ,
SQL Server ,
.NET
Tags
SQL Server Integration Services ,
Oracle

From day one SQL Server Integration Services has had the ability to access third-party databases via both ODBC and OleDB. However these are often much slower than the native interfaces exposed by the database.

To help remedy this third party vendors such as Attunity develop connectors that give SSIS developers direct access to the native interfaces. In a deal with Microsoft, they are giving away their SSIS connectors for Oracle and Teradata. These are available in both 32 and 64-bit versions from the Microsoft Download Center.

Oracle support includes 9.2.0.4 and later on x86, x64, and ia64. Teradata support is for versions 2R6.0, 2R6.1, 2R6.2 and 12.0 on x86 and x64.

RelatedVendorContent

Using Drools? See what you're missing! Get the Power of Drools with the Assurance of Red Hat

Getting Started with Stratos - an Open Source Cloud Platform

The Agile Tester

Agile Maturity Model Applied to Building and Releasing Software

Complimentary Gartner (Hype Cycle for Cloud Security) Report

No comments

Watch Thread Reply

Educational Content

Jesper Boeg on Priming Kanban

In this interview, Jesper Boeg, author of the new InfoQ book – Priming Kanban, discusses the keys to using Kanban effectively, and how to get started if you are currently using other approaches.

New-age Transactional Systems - Not Your Grandpa's OLTP

John Hugg discusses high volume transaction processing applications with high and low frequency profiles, and how VoltDB can be used for that purpose.

Cool Code

Kevlin Henney examines code samples to see what can be learned from them starting from the premise that one won’t write great code unless he knows how to read it.

Collaboration: At the Extremities of Extreme

Jason Ayers share the observations he made watching a team of developers collaborating in real time on the same code base, pushing XP, pair programming and continuous integration to their extremes.

Yesod Web Framework

Michael Snoyman presents Yesod, a web framework written in Haskell and containing a web server, templating, ORM, libraries (templating, gravatar, etc.).

Transactions without Transactions

Richard Kreuter and Kyle Banker on how to avoid classical RDBMS transactional systems by using compensation mechanisms, transactional messaging or transactional procedures.

Attila Szegedi on JVM and GC Performance Tuning at Twitter

Attila Szegedi talks about performance tuning Java and Scala programs at Twitter: how to approach GC problems, the importance of asynchronous I/O, when to use MySQL/Cassandra/Redis, and much more.

10 tips on how to prevent business value risk

One category of risk that project teams need to ensure they address is business value failure – delivering a product that fails to provide value for the business investor.