What's New in SAS Data Integration Studio 4.7


The main enhancements and changes for SAS Data Integration Studio 4.7 include the following:
  • new transformations enable you to call a web service from a job
  • new pass-through processing options
  • new command-line deployment tool
  • new warning message
  • new grid options set specification
  • enhancements to the process flow interface
  • new expression builder functions sets
  • updated usage notes for accessing files in Hadoop and SAS LASR Analytic Server

New Transformations Enable You to Call a Web Service from a Job

Two new transformations enable you to call a web service from a SAS Data Integration Studio job. The SOAP transformation generates SAS SOAP procedure code to access a third-party web service in the context of a job. For more information, see Using SOAP to Access a Third-Party Web Service. The REST transformation generates SAS HTTP procedure code to access a third-party web service in the context of a job. For more information, see Using REST to Access a Third-Party Web Service.

New Pass-Through Processing Options

New pass-through processing options have been added to the Create Table transformation. These options are displayed only when you enable the SQL procedure pass-through option and either a Teradata or Oracle databases is used as the source for the transformation. The options are located in the Database pass-through section of the Options tab in the properties window. The following options are available:
  • Pre CREATE statement options
  • Pre TABLE statement options
  • Post TABLE statement options
  • Post CREATE statement options

New Command-Line Deployment Tool

Now you can deploy one or more jobs by using command-line deployment. This tool enables you run an Ant script to deploy many jobs at once through a simple command line interface. For information, see Using a Command Line to Deploy Jobs.

New Warning Message

A new “Job Has Changed” warning message is displayed when you open a job that has been created, saved, and subsequently changed. This message addresses problems that occur when jobs are changed and later reused or when one user changes a job without notifying other users. The message enables you to review a description of the changes to job before you see the job in its changed state. For information, see Understanding the Job Has Changed Warning. For information about a related warning, see Understanding the Crossed Versions in a Job Warning.

New Grid Options Set Specification

A new Grid options set specification has been added to the Code Generation and SAS Server tabs in the global Options window. The same option was added to the Loop Options tab in the properties window for the Loop transformation. This option enables you to specify a collection of grid options, SAS options, and required resources that are associated with a particular SAS client application. For information about all grid options, see Setting Options for Parallel Processing.

Enhancements to the Process Flow Interface

You can now cut, copy, and paste objects such as jobs, tables, and transformations in the process flow diagram in the Diagram tab. Note, however, that you cannot copy, cut, and paste items between the process flow diagram and the tree hierarchies pane.

New Expression Builder Functions Sets

New Expression Builder functions sets have been added for the following relational databases:
  • DB2 10.1 Functions
  • FedServer TKSQL Functions
  • Greenplum Functions
  • Netezza Functions
  • Postgres Functions
  • Vertica Functions
For more information, see Database Functions.

Updated Usage Notes for Accessing Files in Hadoop and SAS LASR Analytic Server

For information about accessing files in the Hadoop Distributed File System (HDFS) and the SAS® LASR™ Analytic Server, see Usage Notes for SAS LASR Analytic Server and Related Software.
As in past releases, SAS Data Integration Studio provides the following experimental Hadoop transformations for SAS LASR Analytic Servers:
  • The LASR Cluster Stage transformation is used to stage data into a Hadoop cluster.
  • The LASR Loader transformation loads data from Hadoop into a SAS LASR Analytic Server.
  • The LASR Terminate transformation terminates a SAS LASR Analytic server that you started with the LASR Loader transformation.
  • The LASR Unloader transformation unloads data that has previously been loaded into a SAS LASR Analytic Server.
The LASR Loader and LASR Unloader transformations have been improved for this release. In the past, you had to specify a host and port in a file and point the transformations to that file. Now, the transformations get the host and port information from the server metadata. For more information about these experimental transformations, contact SAS Technical Support.