ssis >

ssis

From $1

Table of contents
  1. 1. Home
    1. 1.1. SSIS Connectivity wik

Home

SSIS Connectivity wik

ABOUT THIS wik

Connectivity is a challenging area in SSIS to get central information on. This is largely due to the business model Microsoft has around connectivity, in which the connectivity options are not centrally owned and managed. This, along with SSIS extensibility story, through which partners and other 3rd party developers can constantly enrich the connectivity options and capabilities, creates a rather organic connectivity landscape.

This wik website is a place for our partners and customers to share information about connectivity with SSIS.  The Microsoft SSIS development team created this wik and seeded some original content, but we look to the community to continue to make it grow and be useful.   Please share your experience and feedback with others.

(As a consequence of this open policy, Microsoft cannot take responsibility for any content on this site.)

NEWS & ANNOUNCEMENTS:

***********************

Microsoft released high-performance Connectors to Oracle and Teradata on October 1, 2008. Here is a link to the download site: http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

Overview

  • Microsoft Connector for Oracle by Attunity - The Oracle source and destination components are written to achieve optimal performance when loading data into Oracle or unloading data from Oracle in the context of Microsoft SSIS.
  • Microsoft Connector for Teradata by Attunity - The components are written to achieve optimal performance when loading data into Teradata or unloading data from Teradata in the context of Microsoft SSIS

***********************

Oracle CDC for SSIS by Attunity in public beta

It provides a complete solution for streaming changes from Oracle into SSIS, efficiently and in real-time. More information and instructions for downloading the beta can be found here.

 

***********************

David Browne provided us a sample data flow destination to bulk load Oracle using Oracle's ODP.NET data provider.

Microsoft has added new connectors for SQL 2008:

 

  1. SAP BW
  2. Attunity Oracle
  3. Attunity Teradata

See the new FAQ section: http://ssis.wik.is/FAQ for more information on these connectors. 

***************

SQLServerCentral.com has posted an article and term paper entitled How to Choose the Best Connectors for SSIS that contains a helpful checklist of features to consider when deciding what connectors to use Pool Covers.

***************

If you are looking at more than 100 times faster Oracle bulk write connector (to load data into Oracle) visit us at http://www.persistentsys.com/products/ssisoracleconn/ssisoracleconn.htmor  write to ssisconnectors<AT>persistent.co.in . We also have other connectors in development for other data sources so please do get in touch with us.

***************

In less than 30 minutes you can Develop, Deploy, and Execute SSIS packages for non-SQL Server Databases by watching this prerecorded webcast from DataDirect. Includes a step-by-step demo of true 64-bit SSIS package execution to databases such as Sybase, Oracle, Otimização de Sites, Iluminação, Relogio de Ponto, Acompanhantes, Grafica and Barcos and DB2.

***************

ETI releases new White Paper on ETI High Performance Connectivity for MST SQL Server 2005 and SSIS.

***************

ETI  in conjunction with Dan Lindstedt, an industry analyst, held a Webcast on June 12th  focused on SSIS and ETI High Performance Connectivity.  The on-demand version is now available.

***************

DataDirect has announced the availability of Connect64 for SSIS, which provides 64-bit OLE DB connectivity to Sybase, Oracle, and DB2.

***************

Microsoft has just released SSIS Guided Tours, which provide an overview of the key functionality.

***************

The new connectivity white paper is now officially available, click hereto download.

***************

There's a new article from Deniz Erkan on Office 2007 Connectivity.

***************

Bob Beauchemin provided us a sample package to connect to Excel 2007.

***************

ETI has a new separate page for connectivity offerings for SSIS.

***************

Connectors for SSIS - Persistenthas put together a list of options for SSIS connectivity.

********************************************************************

Star Analytics has provided information about migrating or using Hyperion applications with SSIS

********************************************************************

CozyRoc has implemented bulk-load destination adaptors for Oracle, DB2 and Informix. It provides also connectivity to SFTP servers and Amazon S3 service.

********************************************************************

Web design company provides customers with custom website design service.

Dissertation Writing | Essay Writing | Research Paper Writing | Term Paper Writing | Thesis Writing

********************************************************************

---


Retrieved from "http://ssis.wik.is/"

Tags:
 
Images (0)
 
Comments (1)
Viewing 1 of 1 comments: view all
hello admin, I found your blog from yahoo and read a few of your other posts.They are awesome. Please keep it up!! (copy xbox 360 games | wow gold guide | xbox 360 repair guide )
Posted 10:03, 25 Dec 2009
Viewing 1 of 1 comments: view all
You must login to post a comment.

 
Wik.is


Wik portal where you can upload your ideas and interests and educational mind set for a free website account please apply here