What's New

• JDBC Lookup processor - The processor includes a new Validate Column Mappings property. When selected, all columns listed in the Column Mappings list must exist in the database when the pipeline starts.

• JDBC Multitable Consumer origin - You can select Square Brackets for the Quote Character property. You can also select None when reading from an Oracle or PostgreSQL database. Previously, this was only possible for MySQL and Microsoft SQL Server databases.

• Kafka stages - The Use SASL Mechanism as PLAIN checkbox has been renamed SASL Mechanism and provides a menu of options.

• MongoDB stages - When using LDAP authentication, you can configure the Authentication Mechanism property to select server-driven authentication or plain authentication.

• MySQL Binary Log origin - The origin includes the following new properties:

  • JDBC Connection property - Enables specifying a full JDBC connection string, along with optional parameters. This property replaces the Hostname and Port properties. Upgraded pipelines are not affected.
  • Use Credentials property - Select to specify a user name and password on the Credentials tab.

• Oracle CDC Client origin:

  • You can now use the PEG Parser in production. It is no longer considered a beta feature.
  • Starting in version 3.22.2, the origin generates the following CDC record header attributes:
    • oracle.cdc.precisionTimestamp

    • oracle.cdc.redoValue

    • oracle.cdc.sequence.internal
    • oracle.cdc.sequence.oracle
    • oracle.cdc.undoValue

  The PEG Parser can now be used in production. It is no longer considered a beta feature.
• Salesforce stages:

  • Salesforce stages now support connecting to Salesforce through OAuth. Data Collector uses the Salesforce implementation of JWT Bearer Flow for machine-to-machine OAuth.

  • A new Authentication Method property allows selecting OAuth or basic authentication.

• Salesforce origin - The Replay Option property is now available when the origin processes change or platform events. Previously, it was only available when processing platform events.

• SFTP/FTP/FTPS Client stages - You configure the Protocol property to explicitly state the protocol that you want to use. Previously, this information was inferred from the specified resource URL. This does not affect upgraded pipelines.

When Data Collector version 3.22.x is registered with Control Hub cloud or with Control Hub on-premises version 3.19.x or later, the following stages support using Control Hub connections:

• MySQL Binary Log origin

• PostgreSQL CDC Client origin

• SFTP/FTP/FTPS Client origin, destination, and executor

• New delimited data parser - You can configure a CSV Parser property to enable stages to use the Univocity parser to read delimited data. The Univocity parser can enhance pipeline performance when reading wide delimited files. By default, stages use the Apache Commons parser. Upgraded pipelines are not affected by this change.
• Support bundles - When downloading a support bundle, you can no longer include pipeline snapshots or generated statistics. This is to further protect your data privacy.

• Azure Event Hub stages - The Azure IOT/Event Hub Consumer origin and Azure Event Hub Producer destination support proxies by allowing the use of AMQP over WebSockets.
• Elasticsearch stages:
  • On the Elasticsearch tab, the Cluster HTTP URI property has been split into two properties: HTTP URLs and HTTP Port.
  • On the Security tab, the SSL truststore properties display when you select the Enable SSL property.

  These changes do not affect existing pipelines.

• HTTP Client processor - When using the PATCH HTTP method, you can configure the Request Data and Default Request Content Type properties.
• JDBC Lookup processor - On the Advanced tab, you can configure the On Unknown Type property to determine what occurs when the processor encounters an unexpected type: stop the pipeline or convert the data to String, if possible.
• Kafka stages - Kafka stages allow using SASL_PLAIN security to access Kafka.
• PostgreSQL CDC Client origin - The origin includes two new properties:

  • Status Interval

  • CDC Generator Queue Size

  This enhancement may have upgrade impact.

• Elasticsearch stages
• Snowflake stages

In February 2021, StreamSets released updated Enterprise stage libraries for Databricks and Snowflake.

• Java Keystore credential store - You can specify the number of milliseconds Data Collector waits before reloading the keystore file.

• Amazon stages - You can configure Amazon stages to assume another role when using AWS access keys authentication.

  To assume another role, you first must define the trust policy in AWS that allows the role to be assumed. Then, you configure the required stage properties in Data Collector.

• Azure Data Lake Storage Gen2 stages - The "OAuth Token" authentication method has been renamed to the "OAuth with Service Principal" authentication method. When using this authentication method, you no longer specify an OAuth 2.0 token endpoint. Instead, you specify a tenant ID.

  This change does not affect existing pipelines. During an upgrade, the tenant ID value is retrieved from the full OAuth 2.0 token endpoint value.

• JMS stages:
  • The Use Credentials property has been moved from the JMS tab to the Credentials tab.
  • On the Credentials tab, you can optionally define additional JMS or JNDI security properties, such as the java.naming.security.principal and java.naming.security.credentials properties. The additional security properties support using credential functions to retrieve sensitive information from supported credential stores.

    The additional security properties take precedence over additional JMS configuration properties defined on the JMS tab.

  These changes do not affect existing pipelines.

• Kudu Lookup processor - When the processor performs local caching, you can configure a new Retry on Missing Value property to retry a lookup before using the default value.
• PostgreSQL Metadata processor:
  • By default, the processor creates new columns using names as they appear in the record. Previously, it lowercased column names.
  • You can configure a new Lowercase Column Names advanced property to create columns with lowercased names.

  These changes do not affect existing pipelines.

• Google Pub/Sub Producer destination - The default values for the following properties have changed:
  • Max Outstanding Message Count - The default value is now 1000 messages. Previously, the default was 0 for no maximum.
  • Max Outstanding Request Bytes - The default value is now 8000 bytes. Previously, the default was 0 for no maximum.

  This can affect upgraded pipelines. For more information, see Review Google Pub/Sub Producer Pipelines.

• To Error destination:
  • You can configure the destination to stop the pipeline when the destination receives an error record.
  • You can configure a custom error message that is added to each error record.

• Azure Data Lake Storage Gen2 stages
• JMS stages

• AWS Secrets Manager credential store - When Data Collector runs on an Amazon EC2 instance that has an associated instance profile, you can configure Data Collector to use the instance profile credentials to automatically authenticate with the AWS Secrets Manager.

• Health Inspector - You can now view information about the basic health of your Data Collector. Health Inspector provides a snapshot of how the Data Collector JVM, machine, and network are performing. It also lists related Data Collector configuration details.

StreamSets Accounts enables users without an enterprise account to download the latest version of Data Collector and Transformer and to log into linked Data Collectors and Transformers. Users with a StreamSets enterprise account use the StreamSets Support portal for downloads.

You can use an existing Google or Microsoft account to register with StreamSets Accounts. Or, you can enter an email address and password. After you're registered, you can download the latest Data Collector tarball or access Docker for the latest Data Collector image. StreamSets Accounts provides downloads for the common installation tarball.

After you install Data Collector, you link it to StreamSets Accounts. StreamSets Accounts then provides single sign on authentication for Data Collector. You can change the authentication method as needed.

StreamSets now provides a Data Collector common installation. The common installation is a tarball that contains all core Data Collector functionality as well as commonly-used stage libraries.

This installation allows you to create pipelines easily while using less disk space than the full installation. After you perform the common installation, you can install individual stage libraries as needed.

The common installation is available to users with an enterprise account through the StreamSets Support portal. The common installation is available to all other users through StreamSets Accounts.

• Amazon stages - When Amazon stages use an instance profile to authenticate with Amazon Web Services (AWS), you can configure the stages to assume another role. For example, you might need to assume another role when the IAM policies attached to the instance profile do not grant the required access.

  To assume another role, you first must define the IAM policy in AWS that allows the instance profile to assume a role. Then, you configure the required stage properties in Data Collector.

  Note: Data Collector will provide support to assume another role when using AWS access keys in a future release.
• Kafka stages - The Kafka Consumer, Kafka Multitopic Consumer, and Kafka Producer stages include a Security tab used to configure one of the following options to connect securely to Kafka:
  • SSL/TLS encryption
  • SSL/TLS encryption and authentication
  • Kerberos authentication
  • Kerberos authentication on SSL/TLS

  The keytab properties where you can provide Kerberos credentials have been moved from the Kafka tab to the Security tab.

  Previously, you configured Kafka security by configuring additional Kafka configuration properties.
• Amazon SQS Consumer origin - You can specify the names of queues to process instead of specifying queue name prefixes.
• Google Pub/Sub Subscriber origin:
  • The default value for the Subscriber Thread Pool Size property is now 1.
  • The default value for the Num Pipeline Runners property is also 1.

  These changes do not affect existing pipelines.

• Kinesis Consumer origin - You can configure additional Kinesis configuration properties that you require.
• JMS Consumer origin - The origin includes JMS headers as record header attributes. JMS record header attributes are named as follows: jms.header.<header name>
• Oracle CDC Client origin:
  • You can use the origin to process data from Oracle Real Application Clusters (RAC) 12c, 18c and 19c.
  • You can configure the origin to disable the LogMiner CONTINUOUS_MINE option.
  • When parsing SQL query statements, the origin no longer processes SELECT_FOR_UPDATE statements. This can affect existing pipelines.

    For information about possible upgrade impact, see Update Oracle CDC Client Pipelines.

• Delay processor - You can configure the processor to skip the delay for empty batches.

When Data Collector version 3.19.0 is registered with the Control Hub November release, the following stages will support using Control Hub connections:

• Amazon stages
• Google Cloud stages
• JDBC stages
• Kafka stages
• Kudu stages
• Salesforce stages

In November 2020, StreamSets released the new Azure Synapse Enterprise stage library, which includes the Azure Synapse SQL destination.

• New Data Collector configuration property - The http.access.control.exposed.headers property enables listing a set of headers that can be exposed as part of a cross-domain response.

Pipelines and most pipeline stages include advanced options with default values that should work in most cases. By default, new and upgraded pipelines hide the advanced options. Advanced options can include individual properties or complete tabs.

• HTTP Client processor - The Missing Values Behavior property determines the action that occurs when a request generates no response.
• Amazon S3 stages - "IAM roles" are now known as "instance profiles" in all Amazon S3 stages. This does not affect existing pipelines.

• Error records - Error records include Control Hub job information in jobName and jobId record header attributes.
• Default password for Google Cloud Platform marketplace installation - The default password for Data Collector installed through the Google Cloud Platform marketplace is now the VM Instance Id. Previously, the default password was admin.

• Pipeline run history - The pipeline run history displays the input, output, and error record count for each pipeline run.
• Pipeline run summary - Information about the most recent pipeline run remains available on the Summary tab of the pipeline after the pipeline stops. The summary includes run details such as the start time and duration.
• Pipeline start and stop events - The event records generated when a pipeline starts and stops include fields for the related Control Hub job ID and job name.
• Stage library panel display and stage installation:
  • The stage library panel displays all Data Collector stages, instead of only the installed stages. Stages that are not installed appear disabled, or greyed out.
  • When you click on a disabled stage, you can install the stage library that includes the stage.

• Data Collector production batch size - The default value for the production.maxBatchSize property in the Data Collector configuration file has increased to 50,000 records. This change does not affect existing pipelines.

• Databricks ML Evaluator processor - This processor is deprecated and will be removed in a future release. Do not use the processor in new pipelines.

• SFTP/FTP/FTPS executor - Use the executor to move or remove a file from an SFTP, FTP, or FTPS server upon receiving an event.
• New orchestration stages:
  • Start Job origin - Use this origin to start a Control Hub job.
  • Wait for Job Completion processor - Use this processor to wait for a Control Hub job to complete.
  • Wait for Pipeline Completion processor - Use this processor to wait for a Data Collector, Transformer, or Edge pipeline to complete.

This release includes the following stage enhancements:

• Amazon stages - You can now configure an Authentication Method property to specify whether to connect with an IAM role, with AWS keys, or without authentication. Previously, you could not connect without authentication to a public bucket.
• Amazon S3 stages - The Amazon S3 origin, destination, and executor can use a virtual address model to access objects. Previously, the stages used a path address model.
• HTTP Client stages:
  • HTTP status codes - Error logging details generated by HTTP Client stages now include HTTP status codes.
  • HTTP status header attribute - The HTTP Client stages include an HTTP-Status header attribute that stores the HTTP status for each record.
  • Timeout defaults - The HTTP Client stages no longer allow 0 for the Connection Timeout or Read Timeout properties. The default value for Connect Timeout is now 250000 milliseconds. The default value for Read Timeout is 30000 milliseconds.
• HTTP Client origin record generation - You can configure the origin to generate records for all statuses that are not added to the Per-Status Actions list. You can also specify a field to write the error response body for those records.
• HTTP Server origin authentication enhancements - The origin can create more secure connections using Kerberos authentication. It can also use basic authentication when you enable TLS/SSL.
• JDBC Multitable Consumer origin header attributes - You can enable the origin to create JDBC header attributes.
• Kafka stages allow Kerberos credentials - You can specify Kerberos keytabs and principals in Kafka stages, including the Kafka Consumer, Kafka Multitopic Consumer, and Kafka Producer.
• Kafka Multitopic Consumer origin - You can include Kafka timestamps in the record header.
• Oracle CDC Client origin:
  • 19c support - You can use the Oracle CDC Client origin to read changed data from Oracle 19c in addition to 11g, 12c, and 18c.

  • Property removal - With this release, initialization when Dictionary Source is set to Redo Logs has been improved. As a result, the Duration of Directory Extraction property is no longer needed and has been removed.

• REST Service origin:

  • API Gateway - You can configure the origin to use Data Collector as an API Gateway.

  • Authentication - The origin connect securely using Kerberos authentication. It can also use basic authentication when you enable TLS/SSL.

  • Endpoint URL - The microservice endpoint URL now displays in monitor mode.

• Salesforce origin event enhancement - The no-more-data event record generated by the origin now includes a record-count field that specifies the number of records that were successfully processed.
• Salesforce Lookup processor:
  • Multiple results - You can configure the processor to write multiple return values as a list in a single record instead of returning only the first value or creating a record for each value.
  • Bulk API - You can use the Salesforce Bulk API to look up records in Salesforce based on a SOQL query.
• SFTP/FTP/FTPS Client origin processing delay - You can configure a File Processing Delay property when you want to allow time for a file to be completely written before processing it.
• Start Pipeline processor:
  • Pipeline name support - You can configure the Pipeline ID Type property to enable specifying the pipeline to start based on the pipeline name instead of the pipeline ID.

  • Unique Task Name property - You can specify a unique name for the processor that is included in the output record.

• Start Job processor:
  • Job name support - You can configure the Job ID Type property to enable specifying the Control Hub job to start based on the job name instead of the job ID.
  • Unique Task Name property - You can specify a unique name for the processor that is included in the output record.

This release includes the following additional enhancements:

• Default users and groups for cloud service provider installations - Data Collector installed through a cloud service provider marketplace now includes only a default admin user account and no default groups.

• Group secrets in credential stores - You can configure Data Collector to validate a user’s group against a comma-separated list of groups allowed to access each secret.

• Required group argument in credential functions - If you do not want to use the group argument in credential functions when working with Data Collector and Control Hub, you can specify the default group using all or all@<organization ID>. StreamSets recommends using all so that you do not need to modify credential functions when migrating pipelines from Data Collector to Control Hub. Previously, you had to use all@<organization ID>.

• MapR 5.x no longer supported - With this release, MapR 5.x stage libraries are no longer supported and no longer available.

• Monitor mode indicator - Monitor mode now displays the following real-time Running icon on the stage that is processing data:

• Data Collector downloads require registration - Data Collector installation packages downloaded from the StreamSets website now require that you register the Data Collector instance with StreamSets. Data Collector enforces the registration at different times, based on the following installation types:
  • A core installation of Data Collector requires registration when you install an additional stage library.
  • A full installation of Data Collector requires registration during your initial login.

  Registration involves submitting your contact information to receive a unique activation code by email and then entering the code in your Data Collector instance to activate the instance and use all functionality.

• Download access for enterprise customers - Customers with an enterprise account can now download all Data Collector installation packages from the StreamSets Support portal. Installation packages downloaded from the Support portal do not require that you register the Data Collector instance.

• Java heap size for cloud service provider installations - Data Collector installed through a cloud service provider marketplace now has a default Java heap size set to 50% of the available memory on the virtual machine.

• Cron Scheduler origin - The origin is no longer considered a Technology Preview feature and is approved for use in production.
• HTTP Server origin- You can now configure the origin either to not require an application ID or to accept requests from one of many application IDs.
• JDBC Multitable Consumer origin - The origin now converts SQL Server columns of the Datetimeoffset data type to the Data Collector Zoned_datetime data type.
• JDBC Query Consumer origin - The origin now converts SQL Server columns of the Datetimeoffset data type to the Data Collector Zoned_datetime data type.
• Start Pipeline origin - The origin is no longer considered a Technology Preview feature and is approved for use in production.

• Control Hub API processor - The processor is no longer considered a Technology Preview feature and is approved for use in production.
• Start Job processor - The processor is no longer considered a Technology Preview feature and is approved for use in production.
• Start Pipeline processor - The processor is no longer considered a Technology Preview feature and is approved for use in production.

• JDBC Query executor - The executor can now run one or more user-defined SQL queries each time it receives an event record. Previously, the executor could only run a single SQL query.

• XML - When an origin reads XML data, you can now configure the origin to include the root element in the generated records. Previously, origins did not include the root element in the generated records.

• Send Response to Origin destination - You can now specify response headers that the destination passes to the REST Service origin in a microservice pipeline.

• Register Data Collector with Control Hub - Data Collector instances that are deployed behind a reverse proxy using user-defined path-based routes can now successfully be registered with Control Hub.

• New stage libraries - This release includes the following new stage library:

  Stage Library Name	Description
  streamsets-datacollector-cdh_kafka_4_1-lib	For the Cloudera distribution of Apache Kafka - CDK 4.1.0 (based on Apache Kafka version 2.2.1).

• Groovy Scripting, JavaScript Scripting, and Jython Scripting - These origins now include two new methods in the batch object:
  • addError(<record>,<String message> - Appends an error record to the batch. The appended error record contains the associated error message. This method replaces the sdc.error.write(<record>, <String message>) method.
  • addEvent(<event record>) - Appends an event to the batch. This method replaces the toEvent(<event record>) method in the sdc object.
• RabbitMQ Consumer - The origin now supports transport layer security (TLS) for connections with a RabbitMQ server. You can configure the required properties on the TLS tab.
• Salesforce - The origin has a new property to configure the streaming buffer size when subscribed to notifications. Configure this property to eliminate buffering capacity errors.
• SQL Server CDC Client - The origin can now be configured to convert unsupported data types into strings and continue processing data.
• SQL Server Change Tracking Client - The origin includes the following enhancements:
  • The origin now interprets a zero in the Fetch Size property as an indication to use the database default fetch size in JDBC statements.
  • The origin can now be configured to convert unsupported data types into strings and continue processing data.

• Azure Event Hub Producer - The destination can now write records as XML data.
• Cassandra - The destination includes the following enhancements:
  • The Disable Batch Insert property has been renamed Enable Batches, and the renamed property is enabled by default.
  • The Request Timeout property has been renamed Write Timeout.
• RabbitMQ Producer - The destination now supports transport layer security (TLS) for connections with a RabbitMQ server. You can configure the required properties on the TLS tab.

• Avro - For schemas located in Confluent Schema Registry, Data Collector now includes a property for you to specify the user information needed to connect to Schema Registry through basic authentication.

• Amazon S3 - The origin now generates event records when it starts processing a new object and when it finishes processing an object.
• Azure Data Lake Storage Gen1 - The origin is no longer considered a Technology Preview feature and is approved for use in production.
• Azure Data Lake Storage Gen2 - The origin is no longer considered a Technology Preview feature and is approved for use in production.
• Google Big Query - The origin now supports JSON service-account credentials pasted directly into the UI.
• Google Cloud Storage - The origin now supports JSON service-account credentials pasted directly into the UI.
• Google Pub/Sub Subscriber - The origin now supports JSON service-account credentials pasted directly into the UI.
• HTTP Client - The origin now supports time functions in the Resource URL property.
• Kafka Consumer - The origin can now be configured to save the Kafka message key in the record. The origin can save the key in a record header attribute, a record field, or both.
• Kafka Multitopic Consumer - The origin can now be configured to save the Kafka message key in the record. The origin can save the key in a record header attribute, a record field, or both.
• Salesforce - The origin has a new Mismatched Types Behavior property, which specifies how to handle fields with types that do not match the schema.
• SFTP/FTP/FTPS Client - The origin has three new timeout properties: Socket Timeout, Connection Timeout, and Data Timeout.

• Field Type Converter - The processor can now convert to the Zoned Datetime data type from the Datetime data type or the Date data type.
• Groovy Evaluator - The processor now supports the use of the sdc wrapper object to access the constants, methods, and objects available to each script type.
• HTTP Client - When responses to requests contain multiple values, the processor can now return the first value, all values in a list in a single record, or all values in separate records.
• JavaScript Evaluator - The processor now supports the use of the sdc wrapper object to access the constants, methods, and objects available to each script type.
• Jython Evaluator - The processor now supports the use of the sdc wrapper object to access the constants, methods, and objects available to each script type.

• Azure Data Lake Storage Gen1 - The destination is no longer considered a Technology Preview feature and is approved for use in production.
• Azure Data Lake Storage Gen2 - The destination is no longer considered a Technology Preview feature and is approved for use in production.
• Cassandra - The destination has new properties to disable batches and to set a timeout for individual write requests.
• Google Big Query - The destination now supports JSON service-account credentials pasted directly into the UI.
• Google Cloud Storage - The destination now supports JSON service-account credentials pasted directly into the UI.
• Google Pub/Sub Subscriber - The destination now supports JSON service-account credentials pasted directly into the UI.
• HTTP Client - The destination now supports time functions in the Resource URL property.
• Kafka Producer - The destination can now pass Kafka message key values stored in a record header attribute to Kafka. On the Data Format tab, you configure the expected format of the key.
• Salesforce - The destination now writes data to Salesforce objects by matching case-sensitive field names. You can override the default field mappings by continuing to define specific mappings.
• SFTP/FTP/FTPS Client - The destination has three new timeout properties: Socket Timeout, Connection Timeout, and Data Timeout.
• Solr destination - The destination has two new timeout properties: Connection Timeout and Socket Timeout.

• ADLS Gen1 File Metadata - The executor is no longer considered a Technology Preview feature and is approved for use in production.
• ADLS Gen2 File Metadata - The executor is no longer considered a Technology Preview feature and is approved for use in production.
• JDBC Query - The executor can now generate events that you can use in an event stream. You can configure the executor to include the number of rows returned or affected by the query when generating events.
• Spark - The executor now includes the following:
  • Additional fields in generated event records to store the user who submitted the job and the time that the job started.
  • Additional JARs property for applications written in Python.

Technology Preview stages include the following image on the stage icon: .

When Technology Preview functionality becomes approved for use in production, the release notes and documentation reflect the change, and the Technology Preview icon is removed from the UI.

• The Data Collector configuration file sdc.properties contains a new stage-specific property, stage.conf_com.streamsets.pipeline.stage.hive.impersonate.current.user. You can set the property to true to enable the Hive Metadata processor, the Hive Metastore destination, and the Hive Query executor to impersonate the current user when connecting to Hive.

• New stage libraries - This release includes the following new stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-cdh_6_3-lib	For the Cloudera CDH version 6.3 distribution of Apache Hadoop.
  streamsets-datacollector-orchestrator-lib	For the orchestration stages.

• Updated stage libraries - This release includes updates to the following stage library:

  Stage Library Name	Description
  streamsets-datacollector-hdp_3_1-lib	For Hortonworks 3.1, the library now includes two additional stages: Spark Evaluator processor Spark executor

• Groovy Scripting - Runs a Groovy script to create Data Collector records.
• JavaScript Scripting - Runs a JavaScript script to create Data Collector records.
• Jython Scripting - Runs a Jython script to create Data Collector records.
• NiFi HTTP Server - Listens for requests from a NiFi PutHTTP processor and processes NiFi FlowFiles.

• Groovy Evaluator, JavaScript Evaluator, and Jython Evaluator - These scripting processors now support the following:
  • User-defined parameters - On the Advanced tab, enter parameters and values. In the script, access the value with the sdc.userParams dictionary.
  • Full-screen script editing - With your cursor in the script field, press either F11 or Esc, depending on your operating system, to toggle full-screen editing.

• Cassandra - The destination has four new properties to help you debug issues with the destination: Connection Timeout, Read Timeout, Consistency Level, and Log Slow Queries.
• RabbitMQ Producer - The destination has a new Set Expiration property, available when setting AMQP message properties on the RabbitMQ tab. Clear the Set Expiration property to disable expiration on messages that the destination sends.

• JDBC Query - The executor can now run queries in parallel to improve throughput. On the Advanced tab, select the Enable Parallel Queries property to have the executor run queries simultaneously on each connection to the database.

• Delimited data format - You can now specify when Data Collector inserts quotes in generated delimited data. The Data Generator processor and destinations that write delimited data include a new Quote Mode property on the Data Format tab when you select a custom delimiter format for delimited data. Configure the Quote Mode property to generate data that quotes all fields, only fields that contain special characters, or no fields.
• Excel data format - In origins that read the Excel data format, you can now configure the origin to read either from all sheets in a workbook or from particular sheets in a workbook. Also, you can configure the origin to skip cells that do not have a corresponding header value.

• f:index() - Returns the index within the parent list field. Returns -1 if the field is not in a list.
• f:parent() - Returns the parent field.
• f:parentPath() - Returns the path of the parent field.
• f:getSiblingWithName(<name>) - Returns the sibling field with the name matching <name>, if the field exists.
• f:hasSiblingWithName(<name>) - Returns true if there is a sibling field with a name matching <name>.
• f:hasSiblingWithValue(<name>, <value>) - Returns true if there is a sibling field with a name matching <name> that has value matching <value>.

• The Data Collector configuration file sdc.properties contains a new stage-specific property, stage.conf_com.streamsets.pipeline.stage.jdbc.drivers.load, where you can list JDBC drivers that Data Collector automatically loads for all pipelines.

• New stage libraries - This release includes the following new stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-cdh_6_1-lib	For the Cloudera CDH version 6.1 distribution of Apache Hadoop.
  streamsets-datacollector-cdh_6_2-lib	For the Cloudera CDH version 6.2 distribution of Apache Hadoop.
  streamsets-datacollector-cdh_spark_2_3_r3-lib	For the Cloudera CDH cluster Kafka with CDS powered by Spark 2.3 release 3.
  streamsets-datacollector-cdh_spark_2_3_r4-lib	For the Cloudera CDH cluster Kafka with CDS powered by Spark 2.3 release 4.

• Legacy stage libraries - The following stage libraries are now legacy stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-hdp_2_6-lib	For the Hortonworks version 2.6.x distribution of Apache Hadoop.
  streamsets-datacollector-hdp_2_6-flume-lib	For the Hortonworks version 2.6.x distribution of Apache Flume.
  streamsets-datacollector-hdp_2_6-hive2-lib	For the Hortonworks version 2.6.x distribution of Apache Hive version 2.1.
  streamsets-datacollector-hdp_2_6_1-hive1-lib	For the Hortonworks version 2.6.1 distribution of Apache Hive version 1.x.
  streamsets-datacollector-hdp_2_6_2-hive1-lib	For the Hortonworks version 2.6.2 distribution of Apache Hive version 1.x.

  Legacy stage libraries that are more than two years old are not included with Data Collector. Though not recommended, you can still install the older stage libraries.

  If you have pipelines that use these legacy stage libraries, you will need to update the pipelines to use a more current stage library or install the legacy stage library. For more information see Update Pipelines using Legacy Stage Libraries.

• Hadoop FS Standalone and MapR FS Standalone - These origins include the following tab and property name changes:

  • The Hadoop FS tab is now the Connection tab.
  • The Hadoop FS URI property is now the File System URI property.
  • The HDFS User property is now the Impersonation User property.
  • The Hadoop FS Configuration Directory property is now the Configuration Files Directory property.
  • The Hadoop FS Configuration property is now the Additional Configuration property.

  The functionality associated with these properties has not changed.

• JDBC Multitable Consumer - The origin now supports using multithreaded partition processing when the primary key or user-defined offset column is an Oracle Timestamp with time zone data type and each row has the same time zone.
• JMS Consumer - The origin now supports reading messages from durable topic subscriptions, which can have only one active subscriber at a time.
• SFTP/FTP/FTPS Client - The origin, formerly called SFTP/FTP Client, now supports FTPS (FTP over SSL). Post processing is now disabled after selecting the Whole File data format, which does not support post processing.

• Couchbase Lookup - Looks up documents in Couchbase Server to enrich records with data.

• SFTP/FTP/FTPS Client - Writes whole files to a URL using SFTP, FTP, or FTPS.

• Pipeline Finisher - The executor includes a new Reset Offset option that ensures that the pipeline processes all available data with each pipeline run.

Technology Preview stages include the following image on the stage icon: .

When Technology Preview functionality becomes approved for use in production, the release notes and documentation reflect the change, and the Technology Preview icon is removed from the UI.

The following Technology Preview stages are available in this release:

• Azure Data Lake Storage Gen1 origin - Reads data from Microsoft Azure Data Lake Storage Gen1.
• Azure Data Lake Storage Gen2 origin - Reads data from Microsoft Azure Data Lake Storage Gen2.
• Azure Data Lake Storage Gen1 destination - Writes data to Microsoft Azure Data Lake Storage Gen1.
• Azure Data Lake Storage Gen2 destination - Writes data to Microsoft Azure Data Lake Storage Gen2.
• ADLS Gen1 File Metadata executor - Changes file metadata, creates an empty file, or removes a file or directory in Microsoft Azure Data Lake Storage Gen1 upon receipt of an event.
• ADLS Gen2 File Metadata executor - Changes file metadata, creates an empty file, or removes a file or directory in Microsoft Azure Data Lake Storage Gen2 upon receipt of an event.

• Pipeline Start menu - The Data Collector toolbar now includes a pipeline Start menu with the following options:

  • Start Pipeline

  • Reset Origin and Start

  • Start with Parameters

  Previously, the Reset Origin and Start option was not available. The Start with Parameters option was located under the More icon.

• Generated events - For stages that generate events, the properties panel now includes a Generated Events tab, which lists and describes the events that origins can generate.

• time:extractNanosecondsFromString(<string>) - Converts a String date with nanoseconds precision to an epoch or UNIX time in milliseconds, and then adds the nanoseconds using the following format: <milliseconds_from_epoch><n><nanoseconds>

  For example, the string ’29/05/2019 10:12:09.123456789’ is converted to 1559124729123<n>456789.

• Antenna Doctor - Data Collector now includes Antenna Doctor, which is a rule-based engine that suggests potential fixes and workarounds to common issues. When needed, you can edit the Data Collector configuration file, sdc.properties, to disable Antenna Doctor or to disable Antenna Doctor from periodically retrieving knowledge base updates from the internet.
• Legacy stage libraries - Package Manager can now install legacy stage libraries.
• Thycotic Secret Server support - Data Collector now integrates with the Thycotic Secret Server credential store system.

• New Stage Libraries - This release includes the following new stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-cdh_5_16-lib	For the Cloudera CDH version 5.16 distribution of Apache Hadoop.
  streamsets-datacollector-kinetica_7_0-lib	For Kinetica 7.0.
  streamsets-datacollector-thycotic-credentialstore-lib	For the Thycotic Secret Server credential store system.

• Legacy Stage Libraries - The following stage libraries are now legacy stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-apache-kafka_0_11-lib	For Kafka version 0.11.x.
  streamsets-datacollector-cdh_5_12-lib	For the Cloudera CDH version 5.12 distribution of Apache Hadoop.
  streamsets-datacollector-cdh_5_13-lib	For the Cloudera CDH version 5.13 distribution of Apache Hadoop.
  streamsets-datacollector-cdh_kafka_2_1-lib	For the Cloudera distribution of Apache Kafka 2.1.x (0.9.0).
  streamsets-datacollector-cdh_kafka_3_0-lib	For the Cloudera distribution of Apache Kafka 3.0.0 (0.11.0).
  streamsets-datacollector-cdh-spark_2_1-lib	For the Cloudera CDH cluster Kafka with CDS powered by Spark 2.1.
  streamsets-datacollector-mapr_5_2-lib	For MapR version 5.2.

  Legacy stage libraries that are more than two years old are not included with Data Collector. Though not recommended, you can still install the older stage libraries.

  If you have pipelines that use these legacy stage libraries, you will need to update the pipelines to use a more current stage library or install the legacy stage library. For more information see Update Pipelines using Legacy Stage Libraries.

Use the Hadoop FS destination when you need to use Azure Active Directory refresh token authentication to connect to Azure Data Lake Storage, or when you want to write to Azure Data Lake Storage in a cluster streaming pipeline. For all other cases, use the existing Azure Data Lake Storage destination.

• Install Data Collector on Microsoft Azure - The process to install Data Collector on Microsoft Azure has been enhanced. Data Collector now automatically starts as a service after the resource is deployed. You no longer need to use SSH to log in to the virtual machine to run the Data Collector installation script and then start Data Collector.

• Teradata Consumer origin - Reads data from multiple Teradata Database tables. To use this origin, you must install the Teradata stage library. This is an enterprise stage library.

• Databricks ML Evaluator - With this release, this processor is no longer considered a Technology Preview feature and is approved for use in production. Also, you can now specify a model path relative to the Data Collector resources directory.
• Field Hasher - The processor now supports hashing with the SHA512 cryptographic hash function.
• Field Remover - In addition to removing fields, and removing fields with null values, the processor now supports removing fields under the following conditions:
  • When the values are empty strings.
  • When the values are null or empty strings.
  • When the values are a specified value.
• Field Renamer - The processor now supports the StreamSets expression language in target field paths. With this feature, you can use string functions to change field names to be all uppercase or lowercase.
• JDBC Lookup - The processor now supports returning multiple matching values as a list in a single record.
• Kudu Lookup - The processor now supports the Decimal data type available with Apache Kudu 1.7 and later.
• MLeap Evaluator - With this release, this processor is no longer considered a Technology Preview feature and is approved for use in production. Also, you can now specify a model path relative to the Data Collector resources directory.
• MongoDB Lookup - The processor includes the following updates to property and tab names:

  • Several properties have moved from the MongoDB tab to a new Lookup tab.

  • The SDC Field to Document Field Mapping property is now known as Document to SDC Field Mappings.

  • The Field Name in Document property is now known as Document Field.

  • The New Field to Save Lookup Result property is now known as Result Field.

• PMML Evaluator - The processor is approved for use in production. This release removes the Technology Preview designation. Also, you can now specify a model path relative to the Data Collector resources directory.
• Salesforce Lookup - The processor now supports using time functions in SOQL queries.
• TensorFlow Evaluator - With this release, this processor is no longer considered a Technology Preview feature and is approved for use in production. Also, you can now specify a model path relative to the Data Collector resources directory.

• MemSQL Fast Loader destination - Inserts data into a MemSQL or MySQL database table with a LOAD statement. To use this destination, you must install the MemSQL stage library. This is an Enterprise stage library.
• Snowflake destination - Writes new or CDC data to tables in a Snowflake database schema. To use this destination, you must install the Snowflake stage library. This is an Enterprise stage library.

• Pipeline metadata - Data Collector now publishes additional pipeline metadata to Cloudera Navigator and Apache Atlas, including the pipeline description, labels, parameters, version, and the user who started the pipeline.

• Parameters for checkboxes and drop-down menus - You can now call pipeline parameters for properties that display as checkboxes and drop-down menus. The parameters must evaluate to a valid option for the property.

• Gateway node requires writable temporary directory - When you run a cluster pipeline, Data Collector now requires that the Java temporary directory on the gateway node is writable. The Java temporary directory is specified by the Java system property java.io.tmpdir. On UNIX, the default value of this property is typically /tmp and is writable.

  For information about upgrading cluster pipelines that previously ran on gateway nodes without a writable temporary directory, see Update Cluster Pipelines.

• String functions - This release includes the following new function:
  • str:lastIndexOf(<string>,<subset>) - Returns the index within a string of the last occurrence of the specified subset of characters.

• Data Collector Security Manager - For enhanced security, the Data Collector configuration file now provides a property to enable the Data Collector Security Manager, instead of the Java Security Manager. The Data Collector Security Manager does not allow stages to access files in the following directories:

  • Configuration directory defined in the SDC_CONF environment variable.

  • Data directory defined in the SDC_DATA environment variable.

  In addition, the Data Collector Security Manager does not allow stages to write to files in the resources directory defined in the SDC_RESOURCES environment variable. Stages can only read files in the resources directory.

  By default, Data Collector uses the Java Security Manager which allows stages to access files in all Data Collector directories.

• HTTP/2 support - Data Collector now provides a property in the Data Collector configuration file to enable support of the HTTP/2 protocol for the UI and API. Because HTTP/2 requires TLS, to enable HTTP/2, configure both the http2.enable and the https.port properties.
• Package Manager - The Package Manager includes the following enhancements:

  • Data Collector now provides a package.manager.repository.links property to enable specifying alternate locations for the Package Manager repository.

  • The Package Manager now displays the list of stages associated with each stage library.

• Data Collector logging - Data Collector now logs the stage instance that generates each log line.

• New Stage Libraries - This release includes the following new stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-cdh_kafka_3_1-lib	Cloudera distribution of Apache Kafka 3.1.0 (1.0.1).
  streamsets-datacollector-kinetica_6_2-lib	For Kinetica 6.2. Includes the KineticaDB destination.

• Updated Stage Libraries - This release includes updates to the following stage libraries:

  Stage Library Name	Description
  streamsets-datacollector-apache-pulsar_2-lib	Apache Pulsar version 2.x.
  streamsets-datacollector-cdh_6_0-lib	Cloudera CDH version 6.0.x distribution of Apache Hadoop. Now includes the following stages: HBase Lookup processor Spark Evaluator processor HBase destination The stage library no longer includes the following stage: Solr destination

• JDBC Multitable Consumer origin enhancement - You can now optionally define a schema exclusion pattern to exclude some schemas from being read. The schema exclusion pattern uses a Java-based regular expression, or regex.

• Kudu Lookup processor enhancements:
  • You can now configure the Maximum Number of Worker Threads property to limit the number of threads that the processor uses.
  • You can now configure an Admin Operation Timeout property to determine how many milliseconds to allow for admin-type operations, such as opening a table or getting a table schema.

• Kudu destination enhancements:
  • You can now configure the Maximum Number of Worker Threads property to limit the number of threads that the destination uses.
  • You can now configure an Admin Operation Timeout property to determine how many milliseconds to allow for admin-type operations, such as opening a table or getting a table schema.

• Data Collector now includes a SPARK_KAFKA_VERSION environment variable that is set to 0.10 by default in the Data Collector environment configuration file - sdc.env.sh or sdcd.env.sh. Do not change this environment variable value. This variable is used only when you run cluster streaming mode pipelines on a Cloudera CDH cluster.

• Directory origin enhancements - The origin includes the following enhancements:
  • The Max Files in Directory property has been renamed to Max Files Soft Limit. As the name indicates, the property is now a soft limit rather than a hard limit. As such, if the directory contains more files than the configured Max Files Soft Limit, the origin can temporarily exceed the soft limit and the pipeline can continue running.

    Previously, this property was a hard limit. When the directory contained more files, the pipeline failed.

  • The origin includes a new Spooling Period property that determines the number of seconds to continue adding files to the processing queue after the maximum files soft limit has been exceeded.

• Einstein Analytics destination enhancement - The Append Timestamp to Alias property is now disabled by default for new pipelines. When disabled, the destination can append, delete, overwrite, or upsert data to an existing dataset. When enabled, the destination creates a new dataset for each upload of data.

  The property was added in version 3.1.0.0 and was enabled by default. Pipelines upgraded from versions earlier than 3.1.0.0 have the property enabled by default.

• Solr destination enhancements - The destination includes the following enhancements:
  • The destination now includes an Ignore Optional Fields property that allows ignoring null values in optional fields when writing records.
  • The destination allows you to configure Wait Flush, Wait Searcher, and Soft Commit properties to tune write performance.

• Edge pipelines now support the following stages:
  • Dev Raw Data Source origin
  • Kafka Producer destination
• Edge pipelines now support the following functions:
  • emptyList()
  • emptyMap()
  • isEmptyMap()
  • isEmptyList()
  • length()
  • record:attribute()
  • record:attributeOrDefault()
  • size()
• When you start SDC Edge, you can now change the default log directory.

• HTTP Client origin enhancement - You can now configure the origin to use the Link in Response Field pagination type. After processing the current page, this pagination type uses a field in the response body to access the next page.
• HTTP Server origin enhancement - You can now use the origin to process the contents of authorized HTTP PUT requests.
• Kinesis Consumer origin enhancement - You can now define tags to apply to the DynamoDB lease table that the origin creates to store offsets.
• MQTT Subscriber origin enhancement - The origin now includes a TOPIC_HEADER_NAME record header attribute that includes the topic information for each record.
• MongoDB origin enhancement - The origin now generates a no-more-data event when it has processed all available documents and the configured batch wait time has elapsed.
• Oracle CDC Client origin enhancement - You can now specify the tables to process by using SQL-like syntax in table inclusion patterns and exclusion patterns.
• Salesforce origin enhancements - The origin includes the following enhancements:
  • The origin can now subscribe to Salesforce platform events.
  • You can now configure the origin to use Salesforce PK Chunking.
  • When necessary, you can disable query validation.
  • You can now use Mutual Authentication to connect to Salesforce.

• New Field Replacer processor - A new processor that replaces values in fields with nulls or with new values.

  The Field Replacer processor replaces the Value Replacer processor which has been deprecated. The Field Replacer processor lets you define more complex conditions to replace values. For example, the Field Replacer can replace values which fall within a specified range. The Value Replacer cannot replace values that fall within a specified range.

  StreamSets recommends that you update Value Replacer pipelines as soon as possible.

• New Postgres Metadata processor - A new processor that determines when changes in data structure occur and creates and alters PostgreSQL tables accordingly. Use as part of the Drift Synchronization Solution for Postgres in development or testing environments only.
• Aggregator processor enhancements - The processor includes the following enhancements:
  • Event records now include the results of the aggregation.
  • You can now specify the root field for event records. You can use a String or Map root field. Upgraded pipelines retain the previous behavior, writing aggregation data to a String root field.
• JDBC Lookup processor enhancement - The processor includes the following enhancements:
  • You can now configure a Missing Values Behavior property that defines processor behavior when a lookup returns no value. Upgraded pipelines continue to send records with no return value to error.
  • You can now enable the Retry on Cache Miss property so that the processor retries lookups for known missing values. By default, the processor always returns the default value for known missing values to avoid unnecessary lookups.
• Kudu Lookup processor enhancement - The processor no longer requires that you add a primary key column to the Key Columns Mapping. However, adding only non-primary keys can slow the performance of the lookup.
• Salesforce Lookup processor enhancement - You can now use Mutual Authentication to connect to Salesforce.

• New Aerospike destination - A new destination that writes data to Aerospike.
• New Named Pipe destination- A new destination that writes data to a UNIX named pipe.
• Einstein Analytics destination enhancements - The destination includes the following enhancements:
  • You can specify the name of the edgemart container that contains the dataset.
  • You can define the operation to perform: Append, Delete, Overwrite, or Upsert.
  • You can now use Mutual Authentication to connect to Salesforce.
• Elasticsearch destination enhancement - You can now configure the destination to merge data which performs an update with doc_as_upsert.
• Salesforce destination enhancement - The destination includes the following enhancements:
  • The destination can now publish Salesforce platform events.
  • You can now use Mutual Authentication to connect to Salesforce.

• Log data format enhancement - Data Collector can now process data using the following log format types:
  • Common Event Format (CEF)
  • Log Event Extended Format (LEEF)

• Error record functions - This release includes the following new function:
  • record:errorStackTrace() - Returns the error stack trace for the record.
• Time functions - This release includes the following new functions:
  • time:dateTimeZoneOffset() - Returns the time zone offset in milliseconds for the specified date and time zone.
  • time:timeZoneOffset() - Returns the time zone offset in milliseconds for the specified time zone.
• Miscellaneous functions - This release includes the following changed and new functions:
  • runtime:loadResource() - This function has been changed to trim any leading or trailing whitespace characters from the file before returning the value in the file. Previously, the function did not trim white space characters - you had to avoid including unnecessary characters in the file.
  • runtime:loadResourceRaw() - New function that returns the value in the specified file, including any leading or trailing whitespace characters in the file.

• Apache Kudu 1.6
• Cloudera 5.13 distribution of Apache Kafka 2.1
• Cloudera 5.14 distribution of Apache Kafka 2.1
• Cloudera CDH 5.14 distribution of Hadoop
• Kinetica 6.1

• Data Collector classpath validation - Data Collector now performs a classpath health check upon starting up. The results of the health check are written to the Data Collector log. When necessary, you can configure Data Collector to skip the health check or to stop upon errors.
• Support bundle Data Collector property - You can configure a property in the Data Collector configuration file to have Data Collector automatically upload support bundles when problems occur. The property is disabled by default.
• Redirect registered Data Collector user logins property - You can enable a property in the Control Hub configuration file, dpm.properties, to redirect Data Collector user logins to Control Hub using the HTML meta refresh method.
• Runtime properties enhancement - You can now use environment variables in runtime properties.

• Java requirement - Data Collector now supports both Oracle Java 8 and OpenJDK 8.
• RPM packages - StreamSets now provides the following Data Collector RPM packages:
  • EL6 - Use to install Data Collector on CentOS 6, Oracle Linux 6, or Red Hat Enterprise Linux 6
  • EL7 - Use to install Data Collector on CentOS 7, Oracle Linux 7, or Red Hat Enterprise Linux 7.

  Previously, StreamSets provided a single RPM package used to install Data Collector on any of these operating systems.

• New Amazon SQS Consumer origin - An origin that reads messages from Amazon Simple Queue Service (SQS). Can create multiple threads to enable parallel processing in a multithreaded pipeline.
• New Google Cloud Storage origin - An origin that reads fully written objects in Google Cloud Storage.
• New MapR DB CDC origin - An origin that reads changed MapR DB data that has been written to MapR Streams. Can create multiple threads to enable parallel processing in a multithreaded pipeline.
• New MapR Multitopic Streams Consumer origin - An origin that reads messages from multiple MapR Streams topics. It can create multiple threads to enable parallel processing in a multithreaded pipeline.
• New UDP Multithreaded Source origin - The origin listens for UDP messages on one or more ports and queues incoming packets on an intermediate queue for processing. It can create multiple threads to enable parallel processing in a multithreaded pipeline.
• New WebSocket Client origin - An origin that reads data from a WebSocket server endpoint.
• New Windows Event Log origin - An origin that reads data from Microsoft Windows event logs. You can use this origin only in pipelines configured for edge execution mode.
• New Sensor Reader development origin - A development origin that generates sample atmospheric data for edge pipelines.
• Amazon S3 origin enhancements:
  • The origin now produces no-more-data events and includes a new socket timeout property.
  • You can now specify the number of times the origin retries a query. The default is three.
• Directory origin enhancement - The origin can now use multiple threads to perform parallel processing of files.
• HTTP Client origin enhancement - The origin can now log request and response data to the Data Collector log.
• JDBC Multitable Consumer origin enhancements:
  • The origin can now use non-incremental processing for tables with no primary key or offset column.
  • You can now specify an Init Query to be executed after establishing a connection to the database, before performing other tasks. This can be used, for example, to modify session attributes.
  • A new Queries Per Second property determines how many queries can be run every second.

    This property replaces the Query Interval property. For information about possible upgrade impact, see JDBC Multitable Consumer Query Interval Change.

• JDBC Query Consumer origin enhancements:
  • You can now specify an Init Query to be executed after establishing a connection to the database, before performing other tasks. This can be used, for example, to modify session attributes.
  • The Microsoft SQL Server CDC functionality in the JDBC Query Consumer origin is now deprecated and will be removed from the origin in a future release. For upgrade information, see Update JDBC Query Consumer Pipelines used for SQL Server CDC Data.
• Kafka Multitopic Consumer origin enhancement - The origin is now available in the following stage libraries, in addition to the Apache Kafka 0.10 stage library:

  • Apache Kafka 0.9

  • CDH Kafka 2.0 (0.9.0) and 2.1 (0.9.0)

  • HDP 2.5 and 2.6

• Kinesis Consumer origin enhancement - You can now specify the number of times the origin retries a query. The default is three.
• Oracle CDC Client origin enhancements:
  • When using SCNs for the initial change, the origin now treats the specified SCN as a starting point rather than looking for an exact match.
  • The origin now passes raw data to the pipeline as a byte array.
  • The origin can now include unparsed strings from the parsed SQL query for unsupported data types in records.
  • The origin now uses local buffering instead of Oracle LogMiner buffering by default. Upgraded pipelines require no changes.
  • The origin now supports reading the Timestamp with Timezone data type. When reading Timestamp with Timezone data, the origin includes the offset with the datetime data in the Data Collector Zoned Datetime data type. It does not include the time zone ID.
• SQL Server CDC Client origin enhancements - You can now perform the following tasks with the SQL Server CDC Client origin:
  • Process CDC tables that appear after the pipeline starts.
  • Check for schema changes and generate events when they are found.

  • In addition, a new Capture Instance Name property replaces the Schema and Table Name Pattern properties from earlier releases.

    You can simply use the schema name and table name pattern for the capture instance name. Or, you can specify the schema name and a capture instance name pattern, which allows you to specify specific CDC tables to process when you have multiple CDC tables for a single data table.

    Upgraded pipelines require no changes.

• UDP Source origin enhancement - The Enable Multithreading property that enabled using multiple epoll receiver threads is now named Use Native Transports (epoll).

• New Aggregator processor - A processor that aggregates data within a window of time. Displays the results in Monitor mode and can write the results to events.
• New Delay processor - A processor that can delay processing a batch of records for a specified amount of time.
• Field Type Converter processor enhancement - You can now convert strings to the Zoned Datetime data type, and vice versa. You can also specify the format to use.
• Hive Metadata processor enhancement - You can now configure additional JDBC configuration properties to pass to the JDBC driver.
• HTTP Client processor enhancements:
  • The processor can now log request and response data to the Data Collector log.
  • The Rate Limit now defines the minimum amount of time between requests in milliseconds. Previously, it defined the time between requests in seconds. Upgraded pipelines require no changes.
• JDBC Lookup and JDBC Tee processor enhancements - You can now specify an Init Query to be executed after establishing a connection to the database, before performing other tasks. This can be used, for example, to modify session attributes.
• Kudu Lookup processor enhancement - The Cache Kudu Table property is now named Enable Table Caching. The Maximum Entries to Cache Table Objects property is now named Maximum Table Entries to Cache.
• Salesforce Lookup processor enhancement - You can use a new Retrieve lookup mode to look up data for a set of records instead of record-by-record. The mode provided in previous releases is now named SOQL Query. Upgraded pipelines require no changes.

• New Google Cloud Storage destination - A new destination that writes data to objects in Google Cloud Storage. The destination can generate events for use as dataflow triggers.
• New KineticaDB destination - A new destination that writes data to a Kinetica table.
• Amazon S3 destination enhancement - You can now specify the number of times the destination retries a query. The default is three.
• Hive Metastore destination enhancement - You can now configure additional JDBC configuration properties to pass to the JDBC driver.
• HTTP Client destination enhancements:
  • The destination can now log request and response data to the Data Collector log.
  • You can now use the HTTP Client destination to write Avro, Delimited, and Protobuf data in addition to the previous data formats.
• JDBC Producer destination enhancement - You can now specify an Init Query to be executed after establishing a connection to the database, before performing other tasks. This can be used, for example, to modify session attributes.
• Kudu destination enhancement - If the destination receives a change data capture log from the following source systems, you now must specify the source system in the Change Log Format property so that the destination can determine the format of the log: Microsoft SQL Server, Oracle CDC Client, MySQL Binary Log, or MongoDB Oplog.
• MapR DB JSON destination enhancement - The destination now supports writing to MapR DB based on the CRUD operation in record header attributes and the Insert API and Set API properties.
• MongoDB destination enhancements - With this release, the Upsert operation is no longer supported by the destination. Instead, the destination includes the following enhancements:
  • Support for the Replace and Update operations.
  • Support for an Upsert flag that, when enabled, is used with both the Replace and Update operations.

  For information about upgrading existing upsert pipelines, see Update MongoDB Destination Upsert Pipelines.

• Redis destination enhancement - The destination now supports processing data using CRUD operations stored in record header attributes.
• Salesforce destination enhancement - When using the Salesforce Bulk API to update, insert, or upsert data, you can now use a colon (:) or period (.) as a field separator when defining the Salesforce field to map the Data Collector field to. For example, Parent__r:External_Id__c or Parent__r.External_Id__c are both valid Salesforce fields.
• Wave Analytics destination rename - With this release, the Wave Analytics destination is now named the Einstein Analytics destination, following the recent Salesforce rebranding. All of the properties and functionality of the destination remain the same.

• Hive Query executor enhancement - You can now configure additional JDBC configuration properties to pass to the JDBC driver.
• JDBC Query executor enhancement - You can now specify an Init Query to be executed after establishing a connection to the database, before performing other tasks. This can be used, for example, to modify session attributes.

For information about upgrading a version of Data Collector with Cloudera Navigator integration enabled, see Disable Cloudera Navigator Integration.

• CyberArk - Data Collector now provides a credential store implementation for CyberArk Application Identity Manager. You can define the credentials required by external systems - user names or passwords - in CyberArk. Then you use credential expression language functions in JDBC stage properties to retrieve those values, instead of directly entering credential values in stage properties.
• Supported stages - You can now use the credential functions in all stages that require you to enter sensitive information. Previously, you could only use the credential functions in JDBC stages.

• StreamSets Control Hub - With this release, we have created a new product called StreamSets Control Hub^TM that includes a number of new cloud-based dataflow design, deployment, and scale-up features. Since this release is now our core service for controlling dataflows, we have renamed the StreamSets cloud experience from "Dataflow Performance Manager (DPM)" to "StreamSets Control Hub".

  DPM now refers to the performance management functions that reside in the cloud such as live metrics and data SLAs. Customers who have purchased the StreamSets Enterprise Edition will gain access to all Control Hub functionality and continue to have access to all DPM functionality as before.

  To understand the end-to-end StreamSets Data Operations Platform and how the products fit together, visit https://streamsets.com/products/.

• Aggregated statistics - When working with Control Hub, you can now configure a pipeline to write aggregated statistics to MapR Streams.

• New NetFlow 9 support - Data Collector now supports processing NetFlow 9 template-based messages. Stages that previously processed NetFlow 5 data can now process NetFlow 9 data as well.
• Datagram data format enhancement - The Datagram Data Format property is now named the Datagram Packet Format.
• Delimited data format enhancement - Data Collector can now process data using the Postgres CSV and Postgres Text delimited format types.

• New field path expressions - You can use field path expressions in certain stages to specify the fields to use in an expression.
• New field functions - You can use the following new field functions in field path expressions:
  • f:attribute() - Returns the value of the specified attribute.
  • f:path() - Returns the path of a field.
  • f:type() - Returns the data type of a field.
  • f:value() - Returns the value of a field.
• New string functions - The release includes the following new functions:
  • str:isNullOrEmpty() - Returns true or false based on whether a string is null or is the empty string.
  • str:splitKV() - Splits key-value pairs in a string into a map of string values.

• New stage libraries - This release includes the following new stage libraries:
  • Apache Kafka 1.0
  • Apache Kafka 0.11
  • Apache Kudu 1.5
  • Cloudera CDH 5.13
  • Cloudera Kafka 3.0.0 (0.11.0)
  • Hortonworks 2.6.1, including Hive 1.2
  • Hortonworks 2.6.2, including Hive 1.2 and 2.0
  • MapR version 6.0 (MEP 4)
  • MapR Spark 2.1 (MEP 3)
• Legacy stage libraries - Stage libraries that are more than two years old are no longer included with Data Collector. Though not recommended, you can still download and install the older stage libraries as custom stage libraries.

  If you have pipelines that use these legacy stage libraries, you will need to update the pipelines to use a more current stage library or install the legacy stage library manually, For more information see Update Pipelines using Legacy Stage Libraries.

• Statistics stage library enhancement - The statistics stage library is now included in the core Data Collector installation.

• New data type - Data Collector now supports the Zoned Datetime data type.
• New Data Collector metrics - JVM metrics have been renamed Data Collector Metrics and now include general Data Collector metrics in addition to JVM metrics. The JVM Metrics menu item has also been renamed SDC Metrics.
• Pipeline error records - You can now write error records to Google Pub/Sub, Google Cloud Storage, or an MQTT broker.
• Snapshot enhancements:
  • Standalone pipelines can now automatically take a failure snapshot when the pipeline fails due to a data-related exception.
  • You can now download snapshots through the UI and the REST API.
• Time zone enhancement - Time zones have been organized and updated to use JDK 8 names. This should make it easier to select time zones in stage properties. In the rare case that your pipeline uses a format not supported by JDK 8, edit the pipeline to select a compatible time zone.

• New Kafka Multitopic Consumer origin - A new origin that reads messages from multiple Kafka topics. Creates multiple threads to enable parallel processing in a multithreaded pipeline.
• Kinesis Consumer origin enhancement - You can now configure the origin to start reading messages from a specified timestamp.

• New Google BigQuery destination - A new destination that streams data into Google BigQuery.

• Amazon S3 origin enhancement - You can now specify a Connection Timeout advanced property.
• JDBC Multitable Consumer origin enhancement - You can now use the origin to read from views in addition to tables.
• OPC UA Client origin enhancement - You can now configure channel properties, such as the maximum chunk or message size.
• Oracle CDC Client origin enhancement - You can now configure a JDBC Fetch Size property to determine the minimum number of records that the origin waits for before passing data to the pipeline. When writing to the destination is slow, use the default of 1 record to improve performance. Previously, the origin used the Oracle JDBC driver default of 10 records.

• New MapR FS File Metadata executor - The new executor can change file metadata, create an empty file, or remove a file or directory in MapR each time it receives an event.

• Jython 2.7.1

• New Azure Event Hub Consumer origin - A multithreaded origin that reads data from Microsoft Azure Event Hub.
• OPC UA Client origin enhancement - You can now specify node information in a file. Or have the origin browse for nodes to use based on a specified root node.

• New Schema Generator processor - A processor that generates a schema for each record and writes the schema to a record header attribute.

• New Azure Event Hub Producer destination - A destination that writes data to Microsoft Azure Event Hub.
• New Azure IoT Hub Producer destination - A destination that writes data to Microsoft Azure IoT Hub.

• MapR prerequisites - You can now run the setup-mapr command in interactive or non-interactive mode. In interactive mode, the command prompts you for the MapR version and home directory. In non-interactive mode, you define the MapR version and home directory in environment variables before running the command.

• Hortonworks version 2.6 distribution of Apache Hadoop

• Cloudera distribution of Spark 2.1
• MapR distribution of Spark 2.1

• New buffer size configuration - You can now use a new parser.limit configuration property to increase the Data Collector parser buffer size. The parser buffer is used by the origin to process many data formats, including Delimited, JSON, and XML. The parser buffer size limits the size of the records that origins can process. The Data Collector parser buffer size is 1048576 bytes by default.

• Parquet support - You can now use the Drift Synchronization Solution for Hive to generate Parquet files. Previously, the Data Synchronization Solution supported only Avro data. This enhancement includes the following updates:
  • Hive Metadata processor data format property - Use the new data format property to indicate the data format to use.
  • Parquet support in the Hive Metastore destination - The destination can now create and update Parquet tables in Hive. The destination no longer includes a data format property since that information is now configured in the Hive Metadata processor.

• Origins for multithreaded pipelines - You can now use the following origins to create multithreaded pipelines:

  • CoAP Server origin

  • TCP Server origin

• Multithreaded origin icons - The icons for multithreaded origins now include the following multithreaded indicator:

  For example, here’s the updated Elasticsearch origin icon:

  

• New executors - You can now use the following executors to perform tasks upon receiving an event:
  • Email executor
  • Shell executor

• Pipeline statistics - You can now configure a pipeline to write statistics directly to DPM. Write statistics directly to DPM when you run a job for the pipeline on a single Data Collector.

  When you run a job on multiple Data Collectors, a remote pipeline instance runs on each of the Data Collectors. To view aggregated statistics for the job within DPM, you must configure the pipeline to write the statistics to a Kafka cluster, Amazon Kinesis Streams, or SDC RPC.

• Update published pipelines - When you update a published pipeline, Data Collector now displays a red asterisk next to the pipeline name to indicate that the pipeline has been updated since it was last published.

• New CoAP Server origin - An origin that listens on a CoAP endpoint and processes the contents of all authorized CoAP requests. The origin performs parallel processing and can generate multithreaded pipelines.
• New TCP Server origin - An origin that listens at the specified ports, establishes TCP sessions with clients that initiate TCP connections, and then processes the incoming data. The origin can process NetFlow, syslog, and most Data Collector data formats as separated records. You can configure custom acknowledgement messages and use a new batchSize variable, as well as other expressions, in the messages.
• SFTP/FTP Client origin enhancement - You can now specify the first file to process. This enables you to skip processing files with earlier timestamps.

• Groovy, JavaScript, and Jython Evaluator processor enhancements:
  • You can now include some methods of the sdcFunctions scripting object in the initialization and destroy scripts for the processors.
  • You can now use runtime parameters in the code developed for a Groovy Evaluator processor.
• Hive Metadata processor enhancements:
  • The Hive Metadata processor can now process Parquet data as part of the Drift Synchronization Solution for Hive.
  • You can now specify the data format to use: Avro or Parquet.
  • You can now configure an expression that defines comments for generated columns.
• JDBC Lookup processor enhancements:
  • The JDBC Lookup processor can now return multiple values. You can now configure the lookup to return the first value or to return all matches as separate records.
  • When you monitor a pipeline that includes the JDBC Lookup processor, you can now view stage statistics about the number of queries the processor makes and the average time of the queries.
• Spark Evaluator enhancement - The Spark Evaluator now supports Spark 2.x.

• New CoAP Client destination - A destination that writes to a CoAP endpoint.
• Hive Metastore destination enhancements:
  • The destination can now create and update Parquet tables in Hive.
  • Also, the data format property has been removed. You now specify the data format in the Hive Metadata processor.

    Since the Hive Metastore previously supported only Avro data, there is no upgrade impact.

• Kudu destination enhancement - You can use the new Mutation Buffer Space property to set the buffer size that the Kudu client uses to write each batch.

• New Email executor - Use to send custom emails upon receiving an event. For a case study, see Sending Email During Pipeline Processing.

  • New Shell executor - Use to execute shell scripts upon receiving an event.

  • JDBC Query executor enhancement - A new Batch Commit property allows the executor to commit to the database after each batch. Previously, the executor did not call commits by default.

    For new pipelines, the property is enabled by default. For upgraded pipelines, the property is disabled to prevent changes in pipeline behavior.

  • Spark executor enhancement - The executor now supports Spark 2.x.

• Offset management - Both the REST API and command line interface can now retrieve the last-saved offset for a pipeline and set the offset for a pipeline when it is not running. Use these commands to implement pipeline failover using an external storage system. Otherwise, pipeline offsets are managed by Data Collector and there is no need to update the offsets.

• vault:read enhancement - The vault:read function now supports returning the value for a key nested in a map.

• Support bundles - You can now use Data Collector to generate a support bundle. A support bundle is a ZIP file that includes Data Collector logs, environment and configuration information, pipeline JSON files, resource files, and pipeline snapshots.

  You upload the generated file to the StreamSets support team so that we can use the information to troubleshoot your support tickets.

• TLS property enhancements - Stages that support SSL/TLS now provide the following enhanced set of properties that enable more specific configuration:

  • Keystore and truststore type - You can now choose between Java Keystore (JKS) and PKCS #12 (p-12). Previously, Data Collector only supported JKS.
  • Transport protocols - You can now specify the transport protocols that you want to allow. By default, Data Collector allows only TLSv1.2.
  • Cipher suites - You can now specify the cipher suites to allow. Data Collector provides a modern set of default cipher suites. Previously, Data Collector always allowed the default cipher suites for the JRE.

  To avoid upgrade impact, all SSL/TLS/HTTPS properties in existing pipelines are preserved during upgrade.

• Cluster mode enhancement - Cluster streaming mode now supports Spark 2.x. For information about using Spark 2.x stages with cluster mode, see Cluster Pipeline Limitations.

• Precondition enhancement - Stages with user-defined preconditions now process all preconditions before passing a record to error handling. This allows error records to include all precondition failures in the error message.
• Pipeline import/export enhancement - When you export multiple pipelines, Data Collector now includes all pipelines in a single zip file. You can also import multiple pipelines from a single zip file.

• Register Data Collectors with DPM - If Data Collector uses file-based authentication and if you register the Data Collector from the Data Collector UI, you can now create DPM user accounts and groups during the registration process.
• Aggregated statistics for DPM - When working with DPM, you can now configure a pipeline to write aggregated statistics to SDC RPC. Write statistics to SDC RPC for development purposes only. For a production environment, use a Kafka cluster or Amazon Kinesis Streams to aggregate statistics.

• Dev SDC RPC with Buffering origin - A new development stage that receives records from an SDC RPC destination, temporarily buffering the records to disk before passing the records to the next stage in the pipeline. Use as the origin in an SDC RPC destination pipeline.
• Amazon S3 origin enhancement - You can configure a new File Pool Size property to determine the maximum number of files that the origin stores in memory for processing after loading and sorting all files present on S3.

• New stage libraries - This release supports the following new stage libraries:
  • Kudu versions 1.1 and 1.2

  • Cloudera CDH version 5.10 distribution of Hadoop

  • Cloudera version 5.10 distribution of Apache Kafka 2.1
• Install external libraries using the Data Collector user interface - You can now use the Data Collector user interface to install external libraries to make them available to stages. For example, you can install JDBC drivers for stages that use JDBC connections. Or, you can install external libraries to call external Java code from the Groovy, Java, and Jython Evaluator processors.
• Custom header enhancement - You can now use HTML in the ui.header.title configuration property to configure a custom header for the Data Collector UI. This allows you to specify the look and feel for any text that you use, and to include small images in the header.
• Groovy enhancement - You can configure the processor to use the invokedynamic bytecode instruction.
• Pipeline renaming - You can now rename a pipeline by clicking directly on the pipeline name when editing the pipeline, in addition to editing the Title general pipeline property.

The new multithreaded framework includes the following changes:

• HTTP Server origin - Listens on an HTTP endpoint and processes the contents of all authorized HTTP POST requests. Use the HTTP Server origin to receive high volumes of HTTP POST requests using multiple threads.

• Enhanced Dev Data Generator origin - Can create multiple threads for testing multithreaded pipelines.

• Enhanced runtime statistics - Monitoring a pipeline displays aggregated runtime statistics for all threads in the pipeline. You can also view the number of runners, i.e. threads and pipeline instances, being used.

CDC-enabled origins:

• The MongoDB Oplog and Salesforce origins are now enabled for processing changed data by including the CRUD operation type in the sdc.operation.type record header attribute.

• Though previously CDC-enabled, the Oracle CDC Client and JDBC Query Consumer for Microsoft SQL Server now include CRUD operation type in the sdc.operation.type record header attribute.

  Previous operation type header attributes are still supported for backward-compatibility.

CRUD-enabled stages:

• The JDBC Tee processor and JDBC Producer can now process changed data based on CRUD operations in record headers. The stages also include a default operation and unsupported operation handling.

• The MongoDB and Elasticsearch destinations now look for the CRUD operation in the sdc.operation.type record header attribute. The Elasticsearch destination includes a default operation and unsupported operation handling.

• Groups for file-based authentication - If you use file-based authentication, you can now create groups of users when multiple users use Data Collector. You configure groups in the associated realm.properties file located in the Data Collector configuration directory, $SDC_CONF.

  If you use file-based authentication, you can also now view all user accounts granted access to the Data Collector, including the roles and groups assigned to each user.

• LDAP authentication enhancements - You can now configure Data Collector to use StartTLS to make secure connections to an LDAP server. You can also configure the userFilter property to define the LDAP user attribute used to log in to Data Collector. For example, a username, uid, or email address.

• Proxy configuration for outbound requests - You can now configure Data Collector to use an authenticated HTTP proxy for outbound requests to Dataflow Performance Manager (DPM).

• Java garbage collector logging - Data Collector now enables logging for the Java garbage collector by default. Logs are written to $SDC_LOG/gc.log. You can disable the logging if needed.

• Heap dump for out of memory errors - Data Collector now produces a heap dump file by default if it encounters an out of memory error. You can configure the location of the heap dump file or you can disable this default behavior.
• Modifying the log level - You can now use the Data Collector UI to modify the log level to display messages at another severity level.

• Pipeline renaming - You can now rename pipelines by editing the Title general pipeline property.

• Field attributes - Data Collector now supports field-level attributes. Use the Expression Evaluator to add field attributes.

• New HTTP Server origin - A multithreaded origin that listens on an HTTP endpoint and processes the contents of all authorized HTTP POST requests. Use the HTTP Server origin to read high volumes of HTTP POST requests using multiple threads.

• New HTTP to Kafka origin - Listens on a HTTP endpoint and writes the contents of all authorized HTTP POST requests directly to Kafka. Use to read high volumes of HTTP POST requests and write them to Kafka.

• New MapR DB JSON origin - Reads JSON documents from MapR DB JSON tables.

• New MongoDB Oplog origin - Reads entries from a MongoDB Oplog. Use to process change information for data or database operations.

• Directory origin enhancement - You can use regular expressions in addition to glob patterns to define the file name pattern to process files.

• HTTP Client origin enhancement - You can now configure the origin to use the OAuth 2 protocol to connect to an HTTP service.

• JDBC Query Consumer origin enhancements - The JDBC Consumer origin has been renamed to the JDBC Query Consumer origin. The origin functions the same as in previous releases. It reads database data using a user-defined SQL query through a JDBC connection. You can also now configure the origin to enable auto-commit mode for the JDBC connection and to disable validation of the SQL query.
• MongoDB origin enhancements - You can now use a nested field as the offset field. The origin supports reading the MongoDB BSON timestamp for MongoDB versions 2.6 and later. And you can configure the origin to connect to a single MongoDB server or node.

• Field Type Converter processor enhancement - You can now configure the processor to convert timestamp data in a long field to a String data type. Previously, you had to use one Field Type Converter processor to convert the long field to a datetime, and then use another processor to convert the datetime field to a string.

• HTTP Client processor enhancements - You can now configure the processor to use the OAuth 2 protocol to connect to an HTTP service. You can also configure a rate limit for the processor, which defines the maximum number of requests to make per second.

• JDBC Lookup processor enhancements - You can now configure the processor to enable auto-commit mode for the JDBC connection. You can also configure the processor to use a default value if the database does not return a lookup value for a column.

• Salesforce Lookup processor enhancement - You can now configure the processor to use a default value if Salesforce does not return a lookup value for a field.

• XML Parser enhancement - A new Multiple Values Behavior property allows you to specify the behavior when you define a delimiter element and the document includes more than one value: Return the first value as a record, return one record with a list field for each value, or return all values as records.

• New MapR DB JSON destination - Writes data as JSON documents to MapR DB JSON tables.

• Azure Data Lake Store destination enhancement - You can now use the destination in cluster batch pipelines. You can also process binary and protobuf data, use record header attributes to write records to files and roll files, and configure a file suffix and the maximum number of records that can be written to a file.

• Elasticsearch destination enhancement - The destination now uses the Elasticsearch HTTP API. With this API, the Elasticsearch version 5 stage library is compatible with all versions of Elasticsearch. Earlier stage library versions have been removed. Elasticsearch is no longer supported on Java 7. You’ll need to verify that Java 8 is installed on the Data Collector machine and remove this stage from the blacklist property in $SDC_CONF/sdc.properties before you can use it.

  You can also now configure the destination to perform any of the following CRUD operations: create, update, delete, or index.

• Hive Metastore destination enhancement - New table events now include information about columns and partitions in the table.

• Hadoop FS, Local FS, and MapR FS destination enhancement - The destinations now support recovery after an unexpected stop of the pipeline by renaming temporary files when the pipeline restarts.

• Redis destination enhancement - You can now configure a timeout for each key that the destination writes to Redis.

• Hive Query executor enhancements:

  • The executor can now execute multiple queries for each event that it receives.
  • It can also generate event records each time it processes a query.

• JDBC Query executor enhancement - You can now configure the executor to enable auto-commit mode for the JDBC connection.

• Whole File enhancement - You can now specify a transfer rate to help control the resources used to process whole files. You can specify the rate limit in all origins that process whole files.

• New pipeline functions - You can use the following new pipeline functions to return pipeline information:
  • pipeline:id() - Returns the pipeline ID, a UUID that is automatically generated and used by Data Collector to identify the pipeline.
    Note: The existing pipeline:name() function now returns the pipeline ID instead of the pipeline name since pipeline ID is the correct way to identify a pipeline.

  • pipeline:title() - Returns the pipeline title or name.

• New record functions - You can use the following new record functions to work with field attributes:

  • record:fieldAttribute (<field path>, <attribute name>) - Returns the value of the specified field attribute.
  • record:fieldAttributeOrDefault (<field path>, <attribute name>, <default value>) - Returns the value of the specified field attribute. Returns the default value if the attribute does not exist or contains no value.
• New string functions - You can use the following new string functions to transform string data:

  • str:urlEncode (<string>, <encoding>) - Returns a URL encoded string from a decoded string using the specified encoding format.
  • str:urlDecode (<string>, <encoding>) - Returns a decoded string from a URL encoded string using the specified encoding format.
• New time functions - You can use the following new time functions to transform datetime data:

  • time:dateTimeToMilliseconds (<Date object>) - Converts a Date object to an epoch or UNIX time in milliseconds.
  • time:extractDateFromString(<string>, <format string>) - Extracts a Date object from a String, based on the specified date format.
  • time:extractStringFromDateTZ (<Date object>, <timezone>, <format string>) - Extracts a string value from a Date object based on the specified date format and time zone.
• New and enhanced miscellaneous functions - You can use the following new and enhanced miscellaneous functions:

  • offset:column(<position>) - Returns the value of the positioned offset column for the current table. Available only in the additional offset column conditions of the JDBC Multitable Consumer origin.
  • every function - You can now use the function with the hh() datetime variable in directory templates. This allows you to create directories based on the specified interval for hours.

• New Field Zip processor - Merges two List fields or two List-Map fields in the same record.
• New Salesforce Lookup processor - Performs lookups in a Salesforce object and passes the lookup values to fields. Use the Salesforce Lookup to enrich records with additional data.
• Value Replacer enhancement - You can now replace field values with nulls using a condition.

• Whole file support in the Azure Data Lake Store destination - You can now use the whole file data format to stream whole files to Azure Data Lake Store.

• Installation requirements:
  • Java requirement - Oracle Java 7 is supported but now deprecated. Oracle announced the end of public updates for Java 7 in April 2015. StreamSets recommends migrating to Java 8, as Java 7 support will be removed in a future Data Collector release.
  • File descriptors requirement - Data Collector now requires a minimum of 32,768 open file descriptors.

• Core installation includes the basic stage library only - The core RPM and tarball installations now include the basic stage library only, to allow Data Collector to use less disk space. Install additional stage libraries using the Package Manager for tarball installations or the command line for RPM and tarball installations.

  Previously, the core installation also included the Groovy, Jython, and statistics stage libraries.

• New stage libraries. Data Collector now supports the following stage libraries:
  • Apache Kudu version 1.0.x - Earlier Kudu versions are no longer supported.
  • Cloudera CDH version 5.9 distribution of Apache Hadoop.
  • Cloudera version 5.9 distribution of Apache Kafka 2.0.
  • Elasticsearch version 5.0.x.
  • Google Cloud Bigtable.
  • Hortonworks HDP version 2.5 distribution of Apache Hadoop.
  • MySQL Binary Log.
  • Salesforce.
• LDAP authentication - If you use LDAP authentication, you can now configure Data Collector to connect to multiple LDAP servers. You can also configure Data Collector to support an LDAP deployment where members are defined by uid or by full DN.
• Java garbage collector - Data Collector now uses the Concurrent Mark Sweep (CMS) garbage collector by default. You can configure Data Collector to use a different garbage collector by modifying Java configuration options in the Data Collector environment configuration file.
• Environment variables for Java configuration options. Data Collector now uses three environment variables to define Java configuration options:
  • SDC_JAVA_OPTS - Includes configuration options for all Java versions. SDC_JAVA7_OPTS - Includes configuration options used only when Data Collector is running Java 7.
  • SDC_JAVA8_OPTS - Includes configuration options used only when Data Collector is running Java 8.
• New time zone property - You can configure the Data Collector UI to use UTC, the browser time zone, or the Data Collector time zone. The time zone property affects how dates and times display in the UI. The default is the browser time zone.

• New MySQL Binary Log origin - Reads MySQL binary logs to generate records with change data capture information.
• New Salesforce origin - Reads data from Salesforce. The origin can execute a SOQL query to read existing data from Salesforce. The origin can also subscribe to the Force.com Streaming API to receive notifications for changes to Salesforce data.
• Directory origin enhancement - You can configure the Directory origin to read files from all subdirectories when using the last-modified timestamp for the read order.
• JDBC Query Consumer and Oracle CDC Client origin enhancement - You can now configure the transaction isolation level that the JDBC Query Consumer and Oracle CDC Client origins use to connect to the database. Previously, the origins used the default transaction isolation level configured for the database.

• New Spark Evaluator processor - Processes data based on a Spark application that you develop. Use the Spark Evaluator processor to develop a Spark application that performs custom processing within a pipeline.
• Field Flattener processor enhancements - In addition to flattening the entire record, you can also now use the Field Flattener processor to flatten specific list or map fields in the record.
• Field Type Converter processor enhancements - You can now use the Field Type Converter processor to change the scale of a decimal field. Or, if you convert a field with another data type to the Decimal data type, you can configure the scale to use in the conversion.
• Field Pivoter processor enhancements - The List Pivoter processor has been renamed to the Field Pivoter processor. You can now use the processor to pivot data in a list, map, or list-map field. You can also use the processor to save the field name of the first-level item in the pivoted field.
• JDBC Lookup and JDBC Tee processor enhancement - You can now configure the transaction isolation level that the JDBC Lookup and JDBC Tee processors use to connect to the database. Previously, the origins used the default transaction isolation level configured for the database.
• Scripting processor enhancements - The Groovy Evaluator, JavaScript Evaluator, and Jython Evaluator processors can generate event records and work with record header attributes. The sample scripts now include examples of both and a new tip for generating unique record IDs.
• XML Flattener processor enhancement - You can now configure the XML Flattener processor to write the flattened data to a new output field. Previously, the processor wrote the flattened data to the same field.
• XML Parser processor enhancement. You can now generate records from XML documents using simplified XPath expressions. This enables reading records from deeper within XML documents.

• New Azure Data Lake Store destination - Writes data to Microsoft Azure Data Lake Store.
• New Google Bigtable destination - Writes data to Google Cloud Bigtable.
• New Salesforce destination - Writes data to Salesforce. New Wave Analytics destination. Writes data to Salesforce Wave Analytics. The destination creates a dataset with external data.
• Amazon S3 destination change - The AWS KMS Key ID property has been renamed AWS KMS Key ARN. Data Collector upgrades existing pipelines seamlessly.
• File suffix enhancement. You can now configure a file suffix, such as txt or json, for output files generated by Hadoop FS, Local FS, MapR FS, and the Amazon S3 destinations.
• JDBC Producer destination enhancement - You can now configure the transaction isolation level that the JDBC Producer destination uses to connect to the database. Previously, the destination used the default transaction isolation level configured for the database.
• Kudu destination enhancement - You can now configure the destination to perform one of the following write operations: insert, update, delete, or upsert.

• XML processing enhancement - You can now generate records from XML documents using simplified XPath expressions with origins that process XML data and the XML Parser processor. This enables reading records from deeper within XML documents.
• Consolidated data format properties - You now configure the data format and related properties on a new Data Format tab. Previously, data formats had individual configuration tabs, e.g., Avro, Delimited, Log.

  Related properties, such as Charset, Compression Format, and Ignore Control Characters now appear on the Data Format tab as well.

• Checksum generation for whole files - Destinations that stream whole files can now generate checksums for the files so you can confirm the accurate transmission of the file.

• Add labels to pipelines from the Home page - You can now add labels to multiple pipelines from the Data Collector Home page. Use labels to group similar pipelines. For example, you might want to group pipelines by database schema or by the test or production environment.
• Reset the origin for multiple pipelines from the Home page - You can now reset the origin for multiple pipelines at the same time from the Data Collector Home page.

• Metric rules and alerts enhancements - The gauge metric type can now provide alerts based on the number of input, output, or error records for the last processed batch.

• New file functions - You can use the following new file functions to work with file paths:
  • file:fileExtension(<filepath>) - Returns the file extension from a path.
  • file:fileName(<filepath>) - Returns a file name from a path.
  • file:parentPath(<filepath>) - Returns the parent path of the specified file or directory.
  • file:pathElement(<filepath>, <integer>) - Returns the portion of the file path specified by a positive or negative integer.
  • file:removeExtension(<filepath>) - Removes the file extension from a path.
• New pipeline functions - You can use the following new pipeline functions to determine information about a pipeline:
  • pipeline:name() - Returns the pipeline name.
  • pipeline:version() - Returns the pipeline version when the pipeline has been published to Dataflow Performance Manager (DPM).
• New time functions - You can use the following new time functions to transform datetime data:
  • time:extractLongFromDate(<Date object>, <string>) - Extracts a long value from a Date object, based on the specified date format.
  • time:extractStringFromDate(<Date object>, <string>) - Extracts a string value from a Date object, based on the specified date format.
  • time:millisecondsToDateTime(<long>) - Converts an epoch or UNIX time in milliseconds to a Date object.