What's New

This section describes new Big Data Management features in version 10.2.2 Service Pack 1.

Sqoop

Effective in version 10.2.2 Service Pack 1, you can use the following new Sqoop features.

Connect to SSL-enabled Oracle and Microsoft SQL Server databases

You can configure Sqoop to connect to secure relational databases such as Oracle and Microsoft SQL Server.

Use the appropriate JDBC connection string and the connect argument in the JDBC connection to connect to an SSL-enabled Oracle or Microsoft SQL Server database.

For more information, see the Informatica Big Data Management 10.2.2 Service Pack 1 User Guide.

Support for connection-param-file Sqoop argument

You can define the connection-param-file argument to connect to an SSL-enabled Oracle database. The connection-param-file is a property file that specifies the extra JDBC parameters that Sqoop must use to connect to the SSL-enabled database.

The contents of this file are parsed as standard Java properties and passed into the driver when you create a connection.

You can specify the connection-param-file argument in the Sqoop Arguments field in the JDBC connection.

Use the following syntax:

--connection-param-file <parameter_file_name>

For more information, see the Informatica Big Data Management 10.2.2 Service Pack 1 User Guide.

Big Data Streaming

This section describes the new Big Data Streaming features in version 10.2.2 Service Pack 1.

Amazon S3 Target

Effective in version 10.2.2 Service Pack 1, you can create a streaming mapping to write data to Amazon S3.

Create an Amazon S3 data object to write data to Amazon S3. You can create an Amazon S3 connection to use Amazon S3 as targets. You can create and manage an Amazon S3 connection in the Developer tool or through infacmd.

For more information, see the Informatica Big Data Streaming 10.2.2 Service Pack 1 User Guide.

TIME_RANGE Function

Effective in version 10.2.2 Service Pack 1, you can use the TIME_RANGE function in a Joiner transformation that determines the time range for the streaming events to be joined.

The TIME_RANGE function is applicable only for a Joiner transformation in a streaming mapping.

For more information about the TIME_RANGE function, see the Informatica 10.2.2 Service Pack 1 Transformation Language Reference guide.

Writing Data to Multiple HDFS Files

Effective in version 10.2.2 Service Pack 1, you can use a complex file data object to write the source data to multiple HDFS files. Based on the FileName header port values of the complex file data object, the Data Integration Service creates multiple HDFS files at run time in the target location.

For more information, see the Informatica Big Data Streaming 10.2.2 Service Pack 1 User Guide.

Enterprise Data Catalog

This section describes the new Enterprise Data Catalog feature in version 10.2.2 Service Pack 1.

Supported Resource Types for Standalone Scanner Utility

Effective in version 10.2.2 Service Pack 1, you can extract metadata from the following external sources when they are inaccessible at runtime or offline:

For more information, see the "Metadata Extraction from Offline and Inaccessible Resources" chapter in the Informatica 10.2.2 Service Pack 1 Enterprise Data Catalog Administrator Guide.

Enterprise Data Preparation

This section describes new Enterprise Data Preparation features in version 10.2.2 Service Pack 1.

Revert All Inferred Data Types

Effective in version 10.2.2 Service Pack 1, you can revert all inferred types and data domains applied to source columns in a worksheet back to their original types.

For more information, see the "Prepare Data" chapter in the Informatica 10.2.2 Service Pack 1 Enterprise Data Preparation User Guide.

Prepare Avro and Parquet Files

Effective in version 10.2.2 Service Pack 1, you can sample the hierarchal data in Avro and Parquet files you add to your project as the first step in data preparation. Enterprise Data Preparation converts the Avro or Parquet file structure into a flat structure, and presents the data in a worksheet that you use to prepare the data.

For more information, see the "Prepare Data" chapter in the Informatica 10.2.2 Service Pack 1 Enterprise Data Preparation User Guide.

PowerExchange Adapters for Informatica

This section describes new Informatica adapter features in version 10.2.2 Service Pack 1.

PowerExchange for Hive

Effective in version 10.2.2 Service Pack 1, when you import a Hive table, You can use the Show Default Schema Only option to either clear search results and show only tables that use the default schema or search for tables that use a schema other than the default schema.

For more information, see the Informatica PowerExchange for Hive 10.2.2 Service Pack 1 User Guide.