Skip navigation
1 2 3 … Previous Next

Cloud Application Integration

135 posts

We are delighted to announce the November 2021 release of Cloud Data Integration Taskflows.

 

The release is being rolled out as per the schedule mentioned in the following link: https://network.informatica.com/community/informatica-network/products/cloud-integration/place-calendar.jspa?container=2…

 

Read on to know about the new features in the release.

 

Taskflows - New Features

The November 2021 release contains the following new features and enhancements:

 

  • Additional information in File Watch Task step

When you add a file listener to a File Watch Task step, you see a description and output fields on the File Watch Task tab.
Since the output fields are displayed on the File Watch Task tab, you no longer see a separate Output Fields tab.

 

  • Additional information in Ingestion Task step

When you add a file ingestion task to an Ingestion Task step, you see a description and output fields on the Ingestion Task tab.

Since the output fields are displayed on the Ingestion Task tab, you no longer see a separate Output Fields tab.

 

  • Initial values for temporary fields

You can set an initial value for a temporary field in a taskflow. The value can change during the taskflow run.

 

Please see the What's New Guide for more information.

For the complete Cloud Data Integration documentation, see the documentation portal.

We are delighted to announce the October 2021 release of Cloud Application Integration and Cloud Data Integration Taskflows.

 

The release is being rolled out as per the schedule mentioned in the following link: https://network.informatica.com/community/informatica-network/products/cloud-integration/place-calendar.jspa?container=2…

 

Read on to know about the new features and changed behavior in the release.

 

Application Integration - New Features

The October 2021 release contains the following new features and enhancements:

  • Kafka brokers and configuration properties

When you configure a Kafka connection, you can specify a list of Kafka brokers to ensure high availability.

You can also specify additional configuration properties that are supported by Apache Camel to connect to the Kafka producer and consumer.

  • Process Object field restrictions

The Process Object fields contain new field restrictions, Required and Nullable. You can use them to improve the validation of inbound requests handled by processes.

 

Application Integration - Changed Behavior

The October 2021 release contains the following changed behavior:

  • Email Connector

Effective in the October 2021 release, Application Integration does not support the TLSv1 and TLSv1.1 SMTP SSL protocols. Application Integration supports only the TLSv1.2 protocol.

Email connections to email servers that support only the TLSv1 and TLSv1.1 protocols will fail.

 

  • SAP BAPI Connector

Effective in the October 2021 release, the Trace option is removed from the SAP BAPI connection properties.

You can select the new Jco Trace option in the SAP BAPI connection properties to store JCo call information in a trace file. Previously, you could store JCo call information in a trace file only by defining the Trace parameter in the SAP Additional Parameters field.

 

Taskflows - New Features

The October 2021 release contains the following new features and enhancements:

  • Additional information in Data Task step

When you add a mapping task to a Data Task step, you see a description, input fields, and output fields on the Data Task tab.

The taskflow also returns the following new output fields:

    • Total Transformation Errors. Returns the total number of transformation errors in the Data Task step.
    • First Error Code. Returns the error code for the first error message in the Data Task step.

Note: In Monitor and on the My Jobs page, the value of the Total Transformation Errors and First Error Code output fields is 0 for taskflows that you had run before the October 2021 release. You must republish the existing taskflows to see the correct values of the output fields.

 

  • Support for failing taskflows in Command Task step

You can configure a taskflow to fail on its completion if a Command Task step fails or does not run.

If a Command Task step fails or does not run, the taskflow continues running the subsequent steps. However, after the taskflow completes, the taskflow status is set to failed.

 

  • Support for environment variables in Command Task step

In a Command Task step, you can use environment variables for the script file name, input arguments, and work directory in the input fields.

 

  • Query parameters for monitoring taskflow status

You can use the status resource to query the status of a taskflow using query parameters such as run ID, run status, start time, end time, offset, and row limit.

 

Taskflows - Post upgrade task

Perform the following task after your organization is upgraded to the October 2021 release.

 

Custom query override in taskflows

After you upgrade, existing taskflows that override the custom query of a mapping task might need manual updates.

If a taskflow contains a Data Task step that uses a mapping task with a custom query, and you override the custom query in the taskflow with a query that exceeds 65 characters, the mapping task fails with an error.

To run the taskflow successfully, update the overridden custom query in the Data Task input field. To do this, delete the input field, reselect the input field, and then enter the custom query again. You can use a custom query that exceeds 65 characters.

Note: Before reselecting the Data Task input field, you must clear the cache or switch to the incognito mode.

For more information about overriding a custom query in taskflows, see the following community article:

https://network.informatica.com/docs/DOC-19268

 

Please see the What's New Guide for more information.

For the complete Cloud Application Integration documentation, see the documentation portal.

We are delighted to announce the July 2021 release of Cloud Application Integration.

 

The release is being rolled out as per the schedule mentioned in the following link: https://network.informatica.com/community/informatica-network/products/cloud-integration/place-calendar.jspa?container=2…

 

Read on to know about the new features and changed behavior in the release.

 

Application Integration - Upgrade

You can upgrade the PostgreSQL database of Process Server from version 9.5.2 or 12.4 to version 12.6. Version 12.6 offers security fixes.

You can choose to upgrade at your own convenience by manually running scripts provided by Informatica. The scripts take a backup of the existing database version so that you can restore to the old database version in case of any upgrade issue.

For more information about upgrading the PostgreSQL database, see the following community article:

https://network.informatica.com/docs/DOC-18945

 

Application Integration - Changed Behavior

The July 2021 release contains the following changed behavior:

 

All the Application Integration panels that show process metrics exclude processes that were suspended at any point of time in their lifecycle.

Previously, some panels included suspended processes.
For more information about process metrics, see Operational Insights.

 

Taskflows - New Features

The July 2021 release contains the following new features and enhancements:

 

  • Create taskflow inputs and run a taskflow with taskflow inputs

After you publish a taskflow, you can create one or more taskflow inputs. You can run the taskflow with the taskflow inputs from the taskflow designer. You can create taskflow inputs in the JSON or XML format.

After you run the taskflow, you can view the details of the successful and unsuccessful executions of the taskflow instances.

 

  • New taskflow functions

When you work with taskflows, you can use the following new functions in the Expression Editor:

    • Character function: lpad()
    • Conversion functions: toDecimal(), toInteger()
    • Data cleansing function: in()
    • Date function: lastDay()

 

  • Support for system variables in Command Task step

When you configure the Command Task step, you can use the following system variables in the input fields:

  • $PMRootDir
  • $PMLookupFileDir
  • $PMSessionLogDir
  • $PMBadFileDir
  • $PMCacheDir
  • $PMStorageDir
  • $PMTargetFileDir
  • $PMSourceFileDir
  • $PMExtProcDir
  • $PMTempDir
  • $PMWorkflowLogDir

 

Taskflows - Changed Behavior

The July 2021 release contains the following changed behavior:

 

Taskflow connection parameter

When you run a taskflow as an API, you can use the connection parameter to pass a connection name at run time. Previously, you could use the connection parameter to pass only the connection ID.

Please see the What's New Guide for more information.

For the complete Cloud Application Integration documentation, see the documentation portal.

We are delighted to announce the March 2021 release of Cloud Application Integration.

 

The release is being rolled out as per the schedule mentioned in the following link:

https://network.informatica.com/community/informatica-network/products/cloud-integration/place-calendar.jspa?container=2…

 

This release includes the following new feature:

 

Support for HTTP Response Headers

You can configure multiple HTTP response headers and values for a process that runs only on the Cloud Server. After the process runs, the REST API returns the HTTP response headers that you configured.

 

You can view the response headers on the My Processes page in Application Integration or on the Processes page in Application Integration Console.

 

Please see the What's New Guide for more information.

 

For the complete Cloud Application Integration documentation, see the documentation portal.

We are delighted to announce the February 2021 release of Cloud Application Integration.

 

The release is being rolled out as per the schedule mentioned in the following link: https://network.informatica.com/community/informatica-network/products/cloud-integration/place-calendar.jspa?container=2…

 

Read on to know about the new features and changed behavior in the release.

 

Application Integration - New Features

The February 2021 release offers enhanced resiliency for communication between Agents and Cloud.

 

Application Integration - Upgrade

You can upgrade the PostgreSQL database from version 9.5.2 to 12.4. Version 12.4 offers performance enhancements and new features.

 

You can choose to upgrade at your own convenience by manually running scripts provided by Informatica. The scripts take a backup of the existing database version so that you can restore to the old database version in case of any upgrade issue.

 

For more information about upgrading the PostgreSQL database from version 9.5.2 to 12.4, see the following community article:

https://network.informatica.com/docs/DOC-18945

 

Taskflows - New Features

The February 2021 release contains the following new features and enhancements:

 

  • Developer Productivity
    • Support for new functions in the Expression Editor:
      • Asset detail functions: getAssetLocation, getAssetName, getInstanceStartTime
      • Date functions: ADD_TO_DATE, DATE_DIFF, GET_DATE_PART, TRUNC(Date)
      • Character functions: LTRIM, RTRIM, INSTR
      • Conversion functions: TO_CHAR(Number), TO_CHAR, TO_DATE
      • Test functions: DECODE, IIF, ISNULL
    • Introduction of new Published and Published On columns on the Explore page to view the publish status and publish date of taskflows.

 

  • Taskflow-level Parameterization Support
    • Ability to override the parameter file directory and parameter file name of a mapping task at the taskflow level
    • Ability to override the values of input parameters and in-out parameters of a PowerCenter task at the taskflow level

 

  • Improved Taskflow Execution Resume Options
    • Ability to resume a suspended taskflow from a step that faulted, skip the faulted step, and proceed with the subsequent steps

 

  • Deferred Taskflow Termination
    • Ability to fail a taskflow on its completion if the task associated with a Data Task step does not run or complete successfully

Taskflows - Changed Behavior

The February 2021 release contains the following changed behavior:

  • Taskflow Scheduling
    • A scheduled taskflow runs only if it was manually published or run at least once
    • If you schedule an outdated taskflow that contains unpublished changes, the last published taskflow version will be scheduled
    • Unpublishing a scheduled taskflow will affect the scheduled taskflow runs

       

  • Privilege Check for Status Resource
    • The Monitor - View Job Results privilege is required for users to view the taskflow status using the status resource

 

Please see the What's New Guide attached with this post for more information.

 

For the complete Cloud Application Integration documentation, see the documentation portal.

 

See also: CAI February 2021 Major Release Updates

This three-part video shows how

  • API administrators use API Manager to put APIs under management
  • API operators monitor services and APIs, ensure business processes move forward, and provide support in case of exceptions
  • API and process developers use app integration services to build the processes that become APIs

 

As part of 2021.02.M release effective February/March 2021, there are updates being made to the CAI and Taskflow services.

 

App Integration Meters for Operational Insights

App Integration meters for Operational Insights are being reinitialized for the 2021.02 release to improve performance of analytics reports. This affects customers of the USW1 and USE4 PODs and specific customers activated in other North American, EMEA and APAC environments.

 

The App Integration Meters for Operational Insights are being enabled over the next two months on this schedule:

  • US West1 (USW1): 13th Feb, 2021
  • US East4 (USE4): 20th Feb, 2021
  • EM West1 (EMEA1), US East2 (USE2): 6th March, 2021
  • US West3 (USW3), AP Southeast1 (APJ): 13th March, 2021
  • US West5 (USW5), US East6 (USE6): 20th March, 2021

Taskflow Service We continue to make improvements to the service. Please review the Release Notes. We would like to share changes you need to be aware of. 

 

  • Taskflows now need to be published to be scheduled. This new behavior does not affect previously scheduled Taskflow. Updates to a Taskflow will no longer take effect in a scheduled job until the Taskflow is re-published.
  • The Resume icon is renamed to Resume from faulted step and moved from My Jobs page in Data Integration, and the All Jobs and Running Jobs pages in Monitor to the corresponding taskflow status page.
  • The “Monitor - View Job Results” privilege is now required to view a Taskflow’s status using the Status API. This privilege can be enabled / disabled through Administrator -> User Roles (Click on a role) -> Services (Monitor) -> Features -> Job Results - view

 

App Integration Service Process Server’s PostgreSQL Database The latest version of the PostgreSQL database upgraded from version 9.5.4 to 12.4. Below are some of the benefits that come along with this. 

  • Improved security features and security vulnerability fixes
  • Better performance owing to features such as parallel table scans, parallel query support, parallel joins, and aggregates
  • Support for parallel index scans
  • Performance improvements for queries on tables with partitions
  • Better indexing and auto vacuuming

 

Customers can choose to upgrade at their convenience by manually running a script provided by Informatica. For details about these scripts, please refer https://network.informatica.com/docs/DOC-18945

The Austin Community College District (ACC), the 6th largest in the United States, is a nationally recognized two- and four-year public community college system serving the Austin, Texas, metropolitan area and surrounding Central Texas communities. The college maintains numerous campuses, centers, and distance learning options to serve over 70,000 students in academic, continuing education, and adult education programs annually. ACC’s mission is to promote student success and community development through open door access to an affordable college education for those who want to earn a degree, learn a marketable skill, and advance their careers and serve. The college seeks to serve as the catalyst for social equity, economic development, and personal enrichment.

“Data management and data integration are a ‘constant’ in the life of any data-driven organization. Austin Community College requires continuous evaluation for effectiveness and cost considerations. Partnering with Informatica for us, is a strategic decision that will facilitate and augment our ongoing digital transformation.”

—Imad Costantini, Vice President of IT and CIO, Austin Community College District

 

View Post

Founded in 2007, Sunrun is leading the charge to create a planet run by the sun, building a more sustainable world through making solar simple for customers. The San Francisco-based company has approximately 4,400employees.

 

“Thanks to Informatica Intelligent Cloud Services and Google Cloud, we now have much more capacity for advanced analytics, giving us the insights we need to compete in the fast-changing solar power industry.”

– Harish Ramachandraiah, Director, Engineering & Analytics, Sunrun

 

View Post

Created in 2002 by the integration of six companies from Odebrecht Group and the Mariani Group, Braskem is currently the largest producer of thermoplastic resins in the Americas and the largest producer of polypropylene in the United States. Headquartered in São Paulo, Braskem has approximately 8,000 employees in Brazil, the United States, Mexico, and Germany, in addition to 16 regional offices in other countries.

 

 

“When I originally received the new task of dealing with systems integration, I thought, wow, am I up to the challenge? Informatica helped me understand this new world and I realized that I am up to the task.”

— Vinicius Carneiro da Silveira, IT Solutions Architect, Braskem

 

View Post

 

With award-winning machine learning technology, a multinational footprint, and expert teams focused on defense, IIoT (Industrial Internet of Things), and finance, SparkCognition builds artificial intelligence systems to advance the most important interests of society. Its customers are trusted with protecting and advancing lives, infrastructure, and financial systems across the globe. They turn to SparkCognition to help them analyze complex data, empower decision-making, and transform human and industrial productivity.

 

 

“Informatica gives our customers many options for leveraging more of their enterprise data for AI, which will ultimately make their efforts more successful.”

—Scott Armstrong, Head of Channels and Alliances, SparkCognition

 

View Post

This flagship state university and a global leader in research, entrepreneurship, and innovation, with more than 40,000 students, 14,000 faculty and staff, and 350,000 alumni.

VIEW THE PDF

 

“Informatica Intelligent Cloud Services saves us an incredible amount of time. Without it, modernizing our systems would take much longer.”

– Data Architect, Flagship State University

 

View Post

Maastro provides clinical patient care using radiotherapy and performs clinical radiotherapy research. The Maastro Clinic also collaborates with the Radiotherapy Department and the GROW Research School of the Maastricht University Medical Centre to further optimize cancer treatment through education and scientific research. The independent clinic has approximately 300 employees.

VIEW THE PDF
“Informatica Intelligent Cloud Services enabled us to build complex clinical and research data pipeline. The idea that we could re-use the solution to help other care providers makes me proud.”

—Joeri Veugen, Team Leader DBA/BI, Maastro

View Post

 

For more than 60 years, Bay & Bay Transportation's focus has been to provide best quality transportation and logistics management services. The company is a leading mid-sized, full-service carrier for freight of all kinds throughout North America.

 

“If Bay & Bay achieves a 1% increase in sales revenues from this Informatica implementation, it will translate into a 900% return on the salesforce.com project.”

— Rob Adams, CIO, Bay & Bay Transportation

 

View Post

We are delighted to announce the Fall 2020 October release of Cloud Application Integration. This release is being rolled out across regions according to the following schedule:

 

DateTimeRegion

October 17, 2020

7 - 10 AM PST US W1 & US E2
October 24, 2020 7 - 10 AM PST US W3 & US E4
October 24, 2020 6 - 9 PM PST Ford & JAPAN1
October 27 2020 7 - 10 AM PST AZURE1
November 6, 20207 - 10 PM PST APJ1 & EMEA1
November 8, 20209 PM - 12 AM PST US E6 & Azure3
November 11, 20207 - 10 PM PST CANADA1 & GCP1
November 13, 20207 - 10 AM PST Deloitte Prod

 

The Fall 2020 October release contains new features and enhancements in the following areas:

 

Developer Experience

Service connector import

When you create a service connector by importing a WSDL or Swagger file, you can view the progress and status of the import. If an error occurs during the import, you can also view the details of the error and warnings.

 

Eventing

Change Data Capture support for Salesforce Connector

You can use Salesforce Connector to subscribe to change events in Salesforce and synchronize the corresponding data in an external data store.

Change events represent the changes that have been made to a record. Changes include creating a record, updating an existing record, deleting a record, and undeleting a record.
By default, Salesforce Connector listens to all the entities in an organization that are enabled for Change Data Capture (CDC) in Salesforce. To filter the change events, you can define specific CDC-enabled entities that you want to listen to in the event source.

 

High availability and load balancing support for listener-based connectors

We have improved our message and file listeners. No longer can there be race conditions from multiple and competing readers in a cluster listener for message and file events. Process Server on premises now elects a listener on a per connection basis. Connections are now autonomically distributed across agents in a cluster ensuring that a single listener is elected to handle a connection. Should a node in the cluster fail, a listener on another is automatically elected. This not only improves resilience to failure but also eliminates duplicate processing.

If the Process Server uses a Secure Agent Cluster configuration, the following listener-based connectors support high availability and load balancing:

    • Amazon S3
    • Amazon SQS
    • AMQP
    • File
    • FTP
    • Kafka
    • RabbitMQ
    • Salesforce

 

If a Secure Agent fails during process execution, the process fails over and continues to execute on another Secure Agent within the cluster.

If you use multiple listener-based connections, the Process Server distributes the routes across different Secure Agent machines in a Secure Agent group to ensure load balancing.

 

API Improvements

Cross-origin resource sharing support for processes

You can enable Cross-Origin Resource Sharing (CORS) support for processes and specify the allowed domains and verbs that require CORS support.

CORS support helps API providers to control the domains and verbs that invoke the APIs.

 

Connectivity

Support for additional SAP parameters in SAP BAPI connections

You can configure additional SAP parameters in an SAP BAPI connection. For example, you can configure SAP parameters for load balancing or to use proxy settings when you connect from Cloud Application Integration.

 

Taskflows

Taskflows include the following new features and enhancements:

 

Support for PowerCenter tasks

You can use a PowerCenter task in the Data Task step of a taskflow to control the execution sequence of the task and perform advanced orchestrations.

 

Taskflow suspension on fault and email notification

You can configure a taskflow to suspend on a fault that occurs at the taskflow level. You can also configure the taskflow to send an email notification to specified recipients when it is suspended on a fault.

 

Support for taskflow scope in parameter files

In a parameter file, you can define parameter values at the taskflow scope and linear taskflow level. You can use the same task and parameter file across different taskflows and linear taskflows to provide different parameter values in different taskflow and linear taskflow sections.

 

Please see the What's New document for details (also attached with this post). For more information, see the Release Notes. For the complete Cloud Application Integration documentation, see the documentation portal.

1 2 3 … Previous Next

Filter Blog

By date: By tag: