What's New in SAS Data Integration Studio 4.7

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 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:

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.

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.

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.

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 have been added for the following relational databases: For more information, see Database Functions.

As in past releases, SAS Data Integration Studio provides the following experimental Hadoop transformations for SAS LASR Analytic Servers:

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.