MICROSOFT SSIS CONNECTIVITY
Connect SSIS Packages to Oracle, DB2, Sybase, or Greenplum in 64-Bit Mode
Progress DataDirect Connect64 for SSIS is a solution for connecting Microsoft SQL Server Integration Services (SSIS) packages to non-SQL Server databases such as Oracle, DB2, Sybase, and Greenplum.
- Executes SSIS packages in 64-bit for maximum performance
- No dependency on database client libraries for simpler deployment
- Simultaneous support for multiple database versions
- Fast installation, configuration, and deployment
- Increased reliability and decreased maintenance
Execute SSIS Packages in 64 Bit for Maximum Performance
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 Oracle, DB2, or Sybase.
Simplify Development or Migration of Packages within SSIS
Develop new SSIS packages or migrate existing Data Transformation Services (DTS) packages within Microsoft’s SQL Server Business Intelligence Development Studio using a matching set of 32-bit and 64-bit OLE DB providers for each database to be accessed.
Deploy SSIS Packages Faster
DataDirect Connect64 for SSIS does not require database client libraries, which greatly simplifies deployment and eliminates client versioning issues.
Most SSIS connector solutions are complex to install, lack important functionality, don’t support 64-bit execution, and more often than not, simply don’t work. DataDirect Connect64 for SSIS enables you to get the most of your SSIS deployments by providing easy access to databases such as Oracle, DB2, Sybase, and Greenplum, while offering the best possible reliability and 32-bit or 64-bit runtime package execution performance.
Execute SSIS Packages in 64-Bit for Maximum Performance
SSIS packages are memory intensive and therefore perform best when executed in 64-bit mode. DataDirect Connect64 for SSIS:
- Includes both a 32-bit and 64-bit OLE DB provider for Oracle, DB2, and Sybase to allow both 32-bit or 64-bit execution of SSIS packages
- Uses the same high-performance wire protocol design of DataDirect’s market-leading ODBC drivers
- Communicates at the database’s native (wire) protocol, removing a communication layer and eliminating the need for database client libraries, which decreases overall package execution time
Simplify Development or Migration of Packages within SSIS
Most Microsoft customers choose to execute SSIS packages in 64 bit mode, however, the SQL Server BI Development Studio requires a 32-bit OLE DB provider. To overcome this limitation, DataDirect Connect64 for SSIS:
- Lets you develop new SSIS packages and migrate old DTS packages in SQL Server BI Development studio and execute them in 64-bit mode
- Includes a matching set of 32-bit and 64-bit OLE DB providers for each database that must be accessed
- Enables you to develop SSIS packages that connect to Sybase, Oracle, or DB2 using the SQL Server BI Development Studio and run them in 64-bit mode
Avoid SSIS Package Deployment Headaches and Expense
DataDirect Connect64 for SSIS simplifies deploying SSIS packages because it does not require database client libraries and it simultaneously supports multiple versions of a database:
- Eliminates the need to install and configure database client libraries on each platform where the packages will be deployed
- Avoids client versioning issues that can occur when the SSIS packages deployed on a particular server must access different versions of the same database
- Avoids extensive re-testing and re-qualification of previously deployed SSIS packages due to a database client software upgrade needed to support a new database version
- Allows you to deploy multiple SSIS packages that require access to different versions of a database on the same server
|
OLE DB Providers for Oracle, DB2, Sybase, and Greenplum |
|
|
64-Bit SSIS Connectivity |
|
|
Wire Protocol Design |
|
|
Configuration Manager |
|
|
Security |
|
