Click Graphic for a full-sized image

Overview: DataDirect Connect64 for SSIS

View PDF

DataDirect Connect64 for SSIS enables every phase of the Microsoft SQL Server Integration Services (SSIS) application life cycle from package migration or development, to simplified package deployment, to the best possible 32-bit or 64-bit runtime package execution performance. DataDirect Connect64 for SSIS is designed to enable organizations that need access to databases such as Sybase, Oracle, and DB2 to get the most out of their SSIS deployments.

If you are interested in evaluating DataDirect Connect64 for SSIS for purchase within your organization, please contact us.

If you want to try DataDirect Connect64 for SSIS now, download a free 15-day trial.

Execute SSIS Packages in 64-Bit for Maximum Performance

Due to the memory-intensive nature of what SSIS is designed to do, SSIS packages perform best when executed in 64-bit mode since 64-bit applications are free of the memory constraints of 32-bit applications. DataDirect Connect64 for SSIS includes both a 32-bit and 64-bit OLE DB provider to allow 32-bit or 64-bit execution of SSIS packages that access Sybase, Oracle, and DB2. In addition to allowing 64-bit package execution, Connect64 for SSIS uses the same high-performance wire protocol design of DataDirect's market leading ODBC drivers. This clientless architecture communicates at the database's native (wire) protocol, effectively removing a communication layer and eliminating the need for database client libraries. When used with SSIS packages run in 64-bit mode, Connect64 for SSIS avoids artificial performance bottlenecks caused by memory constraints and decreases overall package execution times.

Simplify Development or Migration of Packages within SSIS

Click Graphic for a full-sized image

Microsoft's SQL Server Business Intelligence Development Studio is the tool that is used to develop new SSIS packages or migrate old Data Transformation Services (DTS) packages to SSIS. Despite the fact that most customers choose to execute their SSIS packages in 64-bit mode, development or migration of packages for SSIS using the SQL Server Business Intelligence Development Studio actually requires a 32-bit OLE DB provider. In order to develop SSIS packages using the SQL Server Business Intelligence Development Studio then execute them in 64-bit mode, DataDirect Connect64 for SSIS contains a matching set of 32-bit and 64-bit OLE DB providers for each database that must be accessed. Without a matched set of 32-bit and 64-bit OLE DB providers, SSIS packages that are developed to connect with databases such as Sybase, Oracle, and DB2 using the SQL Server Business Intelligence Development Studio can not successfully run in 64-bit mode.

Connect64 for SSIS also comes with the DataDirect Configuration Manager to assist in the creation, modification, and management of data sources. Multiple data source can be uniquely configured for each SSIS package deployed so that different connection options can be specified for each database connection used within any SSIS package. The Configuration Manager makes developing SSIS packages for a variety of databases, database types, or use cases quick, easy, and simple to manage.

Avoid SSIS Packages Deployment Headaches

After developing or migrating SSIS packages using the Microsoft SQL Server Business Intelligence Development Studio, the packages must be deployed to the server where they will be run. DataDirect Connect64 for SSIS simplifies the deployment process by eliminating the need to install and configure database client libraries on each platform where the packages will be deployed. Additionally, by not using database client libraries, other deployment problems such as client versioning limitations are avoided. Client versioning limitations occur when the SSIS packages deployed on a particular server must access different versions of the same database. One problem that this causes is extensive retesting and requalification of previously deployed SSIS packages due to a database client software upgrade that is needed to support a newer version of the database. Another problem is the inability to deploy multiple SSIS packages on the same server because there is no version of the database client libraries that can simultaneously support the different database versions being accessed by each package. Connect64 for SSIS connects directly to Sybase, Oracle, or DB2 without the use of database client libraries and is designed to simultaneously support the most current version as well as multiple past versions of each database. Because of its unique architecture, Connect64 for SSIS allows the deployment of multiple SSIS packages that require access to different versions of a database and helps organizations avoid the time and expense involved in SSIS package retesting and requalification.

Connect64 for SSIS Features

• Features a matched set of 32-bit and 64-bit OLE DB providers to allow packages developed using the Microsoft SQL Server Business Intelligence Development Studio to be run in 32-bit or 64-bit mode.
• Eliminates the need for database client libraries. This enables the best available SSIS package performance and speedier package deployment while ensuring simultaneous support for multiple versions of a database from a single server.
• Supports enterprise features like Operating System Authentication and Data Encryption. Through its support of protocols such as Kerberos and SSL, Connect64 for SSIS enables organizations to implement auditing and Single Sign-On initiatives.
• Includes the DataDirect Connect64 for SSIS Configuration Manager to aid in the creation, modification, and management of Connect64 for SSIS data sources
• Backed by the industry’s best technical support organization for immediate, 24 x 7 phone, email and web-based support when you need it most.

Databases Supported

• Sybase Adaptive Server Enterprise 11.x, 12.x, and 15.0

• Oracle
  • version 8i R2 (8.1.6, 8.1.7)
  • versions 9i R1 and R2 (9.0.1, 9.2)
  • versions 10g R1 and R2 (10.1, 10.2)
• DB2
  • v7.1, v7.2 for Linux, UNIX, and Windows
  • v8.1, v8.2 for Linux, UNIX, and Windows
  • v9.1 for Linux, UNIX, and Windows

Support for these additional databases is scheduled for release:

• DB2
  • v7x, v8.1 for z/OS
  • V5R1, V5R2, V5R3, V5R4 for iSeries

If you are interested in support for a database or database version that you do not see listed above, please contact us to request it.

Platform Architectures Supported

• Intel / AMD x86-64 architecture with the following operating systems:
  • Windows Server 2003 64-bit Edition (required for 64-bit runtime support)
  • Windows Server 2003 (32-bit)
  • Windows XP Professional

If you don't see a platform, platform version, or processor architecture combination listed above that you are interested in, contact us to ask about it.