New in SAS Data Integration Studio 4.4

New in SAS Data Integration Studio 4.4

Here is some new features description in SAS DI 4.4

New SQL Transformations

All SQL transformations are now grouped into a single folder called SQL, which is near the bottom of the Transformations tree. The existing Join, Extract, and Set Operators transformations (SAS ETL 4.2) have been moved to this folder.

Six new transformations have been added to broaden and simplify SQL operations in SAS Data Integration Studio jobs.

The following transformations have been added in this release:

1.     The Delete transformation generates a PROC SQL statement that deletes user-selected rows in a single target table. The target table must come from a database management system that provides an implementation of the SQL Delete DML command for which a SAS/ACCESS interface is available.

2.     The Merge transformation inserts new rows and updates existing rows using the SQL Merge DML command. The command was officially introduced in the SQL:2008 standard.

3.     The Update transformation updates user-selected columns in a single target table. The target columns can be updated by case, constant, expression, or subquery. The table must come from a database management system that provides an implementation of the SQL Update DML command for which a SAS/ACCESS interface is available.

4.     The Execute transformation enables you to specify custom SQL code to be executed. It provides SQL templates for supported databases.

5.     The Insert Rows transformation provides a simple SQL interface for inserting rows into tables.

6.     The Create Table transformation provides a simple SQL interface for creating tables.

The new transformations include a new Query Builder window, a simplified interface for building SQL queries.

New DB2 Bulk Table Loader

The new DB2 Bulk Table Loader transformation can take large amounts of data from SAS or most DBMS source tables and bulk load it to a DB2 target. This loader supports multiple load techniques: Import, Load, CLiLoad, and CLiLoad with truncate. It inserts bulk load options where needed. The loader can generate table statistics after the table has been bulk loaded, in order to guide performance tuning.

Experimental Support for Apache Hadoop

Apache Hadoop is an open-source software project that supports scalable, distributed computing. SAS Data Integration Studio has a number of experimental transformations that support Hadoop. For more information, contact SAS Technical Support.

Other New Features:

More than 70 minor enhancements and bug fixes are included in this release. Here are some of the most notable enhancements.

·         The version control feature supports additional releases of Concurrent Versions System server (CVS).

·         A Fix Warning control has been added to the toolbar on the Mapping tab for transformations. This control can be used to fix problems with automatic column mappings. For example, you can use the control to change the target column properties so that they match the source column properties.

·         The Code tab in the property windows for transformations now has a Scroll to User Written Code control. This control becomes active when you select User Written Body on this tab.

·         You can now control whether SAS formats and informats are automatically applied to table columns when you register tables or when code is generated for tables.

·         You can now control whether new instances of most SQL transformations use explicit SQL pass-through processing by default