Skip navigation
1 2 3 Previous Next

Cloud Data Integration

73 posts

The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as many technical details as possible, including new features and functionalities, and where relevant, show you a demo or product walk-through as well.

 

Topic and Agenda

 

 

Despite your cloud investments, you still have on-premise systems you can't do without. If that's not likely to change in the foreseeable future, your business needs tight integration and efficient data management to continue operating effectively.

 

Join Informatica for "Hybrid Data Management with Informatica Operational Insights," a complimentary webinar on monitoring and managing data in complex hybrid environments. It will include:

  • Best practices for integrating and managing a growing number of systems spread across the cloud and on-premises
  • Using Informatica Operational Insights to monitor and manage Informatica investments
  • A live demo of Operational Insights

 

Whether you're a line-of-business application owner or an IT operations manager, you won't want to miss this opportunity to ask our experts about enhancing your hybrid integration platform. Reserve your spot now.

The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as many technical details as possible, including new features and functionalities, and where relevant, show you a demo or product walk-through as well.

 

Topic and Agenda

 

 

Data integration is a core capability for delivering digital transformation and competitive analytics. Next-gen data integration enables you to combine data from various sources with ease of use and scalability. 

 

You may be already using many of the existing IICS Cloud Data Integration (CDI) features but you may not be aware of other existing or recently added features.

  • Did you know that you can access several hundred connectors to databases, cloud data lakes, and on-premises/SaaS applications?
  • Did you know that your IICS CDI allows you to scale your integrations as your business grows with support for high-performance pushdown optimization?
  • Did you know that you can quickly build codeless advanced integrations with wizards and out-of-the-box pre-defined templates?

 

Join Andrew Comstock for a deep dive into IICS Cloud Data Integration with a specific focus on going beyond the traditional use cases:

  • Connect to any of several hundred sources with flexibility and out-of-the-box pre-defined templates
  • Trusted connections to AWS Redshift, Microsoft Azure SQL Data Warehouse, Google BigQuery, and Snowflake cloud databases
  • Going beyond application integration with data integration
  • Learn how to scale your integration processes using serverless deployments

 

Andrew will also demo the IICS CDI Mapping Designer to illustrate the power and flexibility of building simple and complex data integration loads with out-of-the-box advanced data integration transformations.

The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as many technical details as possible, including new features and functionalities, and where relevant, show you a demo or product walk-through as well.

 

Topic and Agenda

 

  • Topic: Meet the Experts Webinar - "Ingesting Data to Your Cloud Data Lake or Cloud Data Warehouse: Deep Dive & Demo"
  • Date: 31 October 2019
  • Time: 9:00 AM Pacific Daylight Time (PDT)
  • Duration: 1 Hour
  • Webinar Registration Link: https://www.informatica.com/about-us/webinars.html?commid=371268&utm_source=support
  • Speakers:
    • Etty Afriat, Director, Product Management, Informatica
    • Vishwa Belur, Director, Product Management, Informatica

 

When building a new Data Warehouse or data lake in the cloud, you need to ingest large volumes of data into the Cloud. The same logic applies to migrating existing data warehouses or data lakes. This could mean tens of thousands of relational tables or data from IoT devices. You need different types of ingestion – file, database or streaming depending on the data you are ingesting into Cloud. Join this technical webinar with a demo and roadmap to learn more about Informatica’s mass ingestion capability on Informatica Intelligent Cloud Integration Services (IICS).

 

Join the experts from Informatica as they deep dive into different types of data ingestion capabilities for:

 

  • Exchanging large data files between on-premises and Cloud repositories
  • Datawarehouse modernization/migration
  • Ingestion of database content onto Cloud Data Lake
  • Streaming & IoT data ingestion onto data lake and messaging hubs

We are hosting a webinar with Kelly Services on September 4, 2019. Ravi Ginjupalli reviews the process to master 4 critical domains, starting with customer, and connecting Informatica MDM with Salesforce through IICS. The webinar is co-presented with Capgemini. This is also a Teradata to Azure migration at Kelly Services. Hear about the story, challenges, and lessons learned at Kelly Services as Ravi Ginjupalli and Venkat Gupta of Capgemini discuss the approach and technology behind their effort.

 

You can register for the webinar on Sept 4, 2019, at 11 AM PDT here: https://www.informatica.com/about-us/webinars.html?commid=367064

 

They realize:

  • 99.99% accuracy in identifying duplicates using MDM match rules
  • 1000 Average number of Accounts weekly (Includes both prospects and new clients)
  • 500k Number of customer loaded during the initial load
  • Eliminated 18% duplicate Customer records in Salesforce
  • 6 month Time to deliver; Salesforce + D&B integration + Hierarchies; 180 tables; 5218 Attributes; 288 mapping

The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as many technical details as possible, including new features and functionalities, and where relevant, show you a demo or product walk-through as well.

 

Topic and Agenda

 

 

Multi-cloud and hybrid architectures make data management complicated. You need a comprehensive next-generation integration platform as a service (iPaaS) to handle new use cases as they emerge.

 

Join us for a Meet the Experts webinar about how to keep up with your evolving data management needs with Informatica Intelligent Cloud Services (IICS):

  • Discover some of our new iPaaS services and capabilities
  • See a demo of IICS Integration at Scale, which uses serverless technology for data integration to help you process data in the cloud
  • Learn how AI-driven capabilities and microservices-based architecture supports use cases such as B2B integration, data quality, master data management, database and streaming ingestion, and more.

 

Investing in SaaS, PaaS, and IaaS means managing more data in more ways across increasingly complex architectures. Register for this webinar to explore how IICS can make it easier.

Webinar: Meet the Experts: Deep-Dive, Demo, Roadmap - Informatica Cloud App/API Integration

 


Join Informatica product experts as they dive deep into the API and application integration capabilities for accelerating your digital transformation. You will learn:

 

  1. How to develop processes, APIs, and connect to any APIs without any coding
  2. What Intelligent APIs are and why Informatica is uniquely qualified to offer these?
  3. About management of integration artifacts and APIs
  4. The “ilities” (performance, scalability, reliability) of our platform
  5. The IaaS, SaaS, and on-prem partners we integrate with

The IICS Summer 2019 release offers several new capabilities that include integration patterns, expanded connectivity, and platform functions. Highlights are listed below.

 

Data Integration

  • Machine learning-based transformation recommendations allow you to get suggestions for the next best transformation based on the mapping you are working on.
  • Improved support for custom, local parameter file locations, support for fully parameterized SQL queries, ability to overwrite connections at runtime using parameter files.
  • Support for invoking taskflows using the RunAJob command line utility and using file listeners. These can be passed as parameters to data tasks for listener-driven events.
  • New and improved taskflow canvas with a more compact layout improving design experience.
  • The SQL transformation now supports ad hoc SQL queries (in addition to Stored Procedures).
  • Intelligent Structure Discovery:
    • Enhancements to existing ISD models with data from additional sample files (JSON & XML) to quickly adapt to data drift.
    • The Structure Parser transformation can now update or change the associated intelligent structure model without breaking unchanged ports mappings which enhances mapping flexibility and allows for fast adaptation to changes in incoming files.
    • Simplified design time experience with the ability to add a prefix or a suffix to existing node names using the bulk action functionality.
    • Enhanced parsing engine support with the ability to discover and parse AVRO files.
  • Mass Ingestion:  
    • Additional sources and targets:  ADLS GEN1 as source, ADLS GEN2 as source and target, Snowflake as source and target.
    • Support for custom actions during file transfer:  compress/decompress, encrypt/decrypt
    • Integration with Enterprise Data Catalog (EDC): select Mass Ingestion source from EDC.
    • Filter files to transfer by file size and date.
    • Optimization for large file handling – resume from point of failure.

 

Application Integration

  • Developer productivity enhancements: new compact canvas, improved diagnostics and debugging 
    • Improved Process and Guide canvas compact layout improving design experience.
    • New validation panels help diagnose service connectors and connection errors.
    • Fault details are now available with every step to diagnose runtime errors and improve debugging. 
  • Guides: Improved page layout and Salesforce Lightning theme
    • Guide Screen step designer has been revamped to provide more real estate to design guides.
    • Salesforce Lightning theme support is now available for guides and the Guide Launcher.
  • Source control and deployment automation 
    • New CLI utility automates export and extract of design assets to any source control system. The package, import and publish capabilities of the CLI provides the ability to deploy full deployments, packages and patches across environments.
    • Sample Jenkins pipeline to help developers adopt continuous integration practices for Application and Data Integration, and help operations staff with the automation of continuous deployments.
  • Expanded pub/sub and messaging capabilities with Salesforce Platform Events and RabbitMQ to compliment the current support for AMQP, JMS, AWS SNS/SQS, Azure Service Bus/Event Hub and Kafka.
    • New support for Salesforce Platform Event and Push Topic events enabling customers to deliver secure, scalable and customizable event notifications within Salesforce or from external sources. 
    • New RabbitMQ native connector providing support for durable queues. 

 

API Management

  • CLAIRE-enabled privacy data leak identification: Privacy data identification in API content, masking or blocking of sensitive personally identifiable information. (This feature is in preview mode).
  • Ability to customize the structure of API URLs.
  • Support for the internationalization of API, group, and organization names.

 

Integration Hub  

  • Governance enhancement: Support for predefined and custom roles with granular privileges that promote governance.

 

B2B Gateway

  • Exchange files with your partners using Cloud AS2.
  • Get insights into your daily gateway activities and statuses with the new dashboard.

 

Platform

  • Asset Dependency feature providing “used by” and “uses” relationship information across all asset types and services for impact analysis.
  • Common Explore enhancements: Changes made by the user to the Explore column settings are now automatically persisted for that user for various filtered views such as “all assets,” “projects & folders,” etc.
  • More control and flexibility in managing users: Grant/deny service level access to a user through assign services capability. Disable users to prevent user logins for both native and SAML authentication mechanisms. REST APIs for user management – users, groups and roles.
  • Ability to start/stop Secure Agent services to optimize computing resources and isolate the need to restart a single service from others.

 

Connectivity Enhancements  

  • New native connectors to connect to CDM/Power BI, Snowflake (V2), MongoDB, Adobe Experience Platform, Ariba (V2), and Cassandra.
  • Updates to existing connectors: Microsoft (MSD 365 Operations, Cosmos DB, ADLS Gen2 and Gen 1, SQL DW), Google (Google Big Query, Google Storage), Amazon (S3, Redshift), Oracle NetSuite, Salesforce, SAP (Concur V2, S/4 HANA) and Greenplum

 

New IICS Services

The IICS Summer 2019 release offers the following new services:

 

Streaming Ingestion (included in Data Ingestion Service)

  • Ingestion of streaming data from logs, Apache Kafka and IoT sources.
  • Supports AWS & Azure ecosystems as targets of Ingestion: Amazon Kinesis Streams, Kinesis Firehose, Amazon S3 and Azure EventHub
  • Supports lightweight transformations at the edge.
  • Real-time monitoring of streaming ingestion jobs.

 

Integration at Scale (included in Data Integration Service)

  • Run data integration jobs at scale on a fully managed spark serverless cluster.
  • Support for AWS ecosystem: S3 & Redshift
  • Auto-tune and scale fully-managed Kubernetes clusters.

 

Operational Insights

  • Operational Insights is now available for IICS cloud services to help with efficient infrastructure monitoring and alerting. IICS cloud services users can monitor the health of a) Secure Agents, b) services running on each Secure Agent, c) Runtime environments and d) subscribed cloud services.
  • Email Alerts can be set on services and Secure Agents for unavailability or excessive resource consumption.

 

Reference 360  

  • Enables business users to manage enterprise reference data in an easy-to-use, configurable, business-friendly user interface.
  • Provides versioning, collaboration and complete life-cycle management of reference data.
  • REST APIs for managing data and meta-data, enabling automation and system integration.
  • Improved stability and performance.

 

 

Data Quality

  • Enable business users to create rule specifications to perform a variety of Data Quality actions including completeness, validation and standardization.
  • Create and manage value lists for data quality operations using dictionaries. Dictionaries can be used to identify, validate and standardize data as part of a rule specification.
  • Embed Data Quality rules in Data Integration mappings to support Data Quality activities in typical data integration scenarios such as data warehousing, data migrations and more.

 

Thank you, 

The IICS Team

This export zip package includes assets that will help you get started with Cloud Data Integration. This zip includes the following assets:

  • Mapping and mapping task to perform simple join across multiple sources.
  • Parameterized mapping to show re-use of mapping logic across multiple objects.
  • Taskflows with decision tasks

ALERT:  for customers using Informatica Cloud

 

To better serve our customers, we are planning to place older connectors and unused connectors in End-of-Life (EOL) or Maintenance Mode mid-2019. if you need a new connector enabled, per the customer action below, please create a shipping case and request we add the new connector to your org(s). The differences between Maintenance Mode and EOL are summarized in table below:

 

Term

Description

Bug Fixes

Enhancements

Connector continues to work

Customer Action

End-of-Life (EOL)

Connector at end-of-life. 
Informatica will no longer support; no bug fixes; no enhancements. 
There will be no automatic migrations, upgrades for existing work.

No

No

No

Connector will no longer work post the next release planned for July; and will not be available in your org anymore.
Please verify you not using any connector, or move mappings to an alternative connector, if available.

Maintenance Mode

Connector in maintenance mode. 
Informatica will no longer enhance; and bug fixes may be considered. 
There will be no automatic migrations, upgrades for existing work. You will need to apply the latest recommended connector and migrate your jobs to the next connector.

Yes

No

Yes

Connector will work post R32.
Customer should consider moving to alternative connector, if available; the alternative connector will continue to be further enhanced as necessary.

 

Am I impacted?

Refer to the list below to determine if you are using one of these connectors. A separate email will be sent to all "Subscription" only customers for these connectors.

 

How do I address the issue?

Please reference Customer Action in table above; and Notes to Customers and Alternative connector columns in table below.

 

The following table shows the connectors planned for end-of-life (EOL) or maintenance mode mid-2019

 

Nr

Data Source

Connector Name

EOL or Maintenance Mode

Alternative Connector

Notes to Customers

1

Amazon QuickSight

Amazon QuickSight

EOL

None

 

2

Arc GIS

Arc GIS

EOL

None

 

3

Attensity Discovery Now

Attensity Discovery Now

EOL

None

 

4

Avature

Avature

EOL

Generic REST V2 / WS Connector

 

5

Birst

Birst

EOL

Birst Cloud Connect

 

6

Cloud File Transfer

Cloud File Transfer

EOL

None

 

7

Club Assistant

ClubAssistant

EOL

None

 

8

DataSift

DataSift

EOL

None

 

9

EPIC

EPIC

EOL

None

 

10

IDVExpress

IDVExpress

EOL

None

 

11

Informatica Data Prep

Informatica Data Prep

EOL

None

 

12

Informatica Rev

Informatica Rev

EOL

None

 

13

Intuit QuickBooks

Intuit Quickbooks

EOL

QuickBooks V2

 

14

Intuit Quickbooks Online

Intuit Quickbooks Online

EOL

QuickBooks V2

 

15

Magento

Magento

EOL

None

 

16

Marketo

Marketo 2

EOL

Marketo V3

 

17

Microsoft Dynamics AX

Microsoft Dynamics AX 2009

EOL

None

 

18

Microsoft Dynamics GP

Microsoft Dynamics GP 2010

EOL

None

New connector on roadmap.

19

Oracle Netsuite

NetSuite (Restlet) Write only

EOL

NetSuite

 

20

Oracle Peoplesoft

Oracle Peoplesoft 9.x

EOL

Use generic REST V2 or WS Connector

 

21

Oracle Taleo Business Edition

Oracle Taleo Business Edition

EOL

Generic REST V2 / WS Connector

 

22

Oracle Taleo Enterprise Edition

Oracle Taleo Enterprise Edition

EOL

Generic REST V2 / WS Connector

 

23

Rapnet

Rapnet

EOL

None

 

24

Rave

Rave

EOL

None

 

25

Reltio

Reltio

EOL

None

 

26

Rev

Rev

EOL

None

 

27

Saaggita

Saaggita

EOL

None

 

28

Salesforce Insights

Salesforce Insights

EOL

None

 

29

Snowflake

Snowflake V1 Connector

EOL

Snowflake Cloud Data Warehouse

 

30

Snowflake

Snowflake Big Data Warehouse

EOL

Snowflake Cloud Data Warehouse

 

31

Sugar CRM

Sugar CRM

EOL

Sugar CRM REST

 

32

Tableau (Server)

Tableau V1

EOL

Tableau V3

 

33

Trackwise

Trackwise

EOL

None

 

34

Vindicia

Vindicia

EOL

None

 

35

Zoho

Zoho

EOL

Generic REST V2 / WS Connector

 

36

Amazon Dynamo DB

Amazon Dynamo DB

Maintenance Mode

None

New connector on roadmap.

37

Anaplan

Anaplan

Maintenance Mode

Anaplan V2

 

38

Apache Hive

Hadoop

Maintenance Mode

Hive Connector

 

39

Box

Box

Maintenance Mode

None

New connector on roadmap.

40

Box

Box API

Maintenance Mode

None

New connector on roadmap.

41

Chatter

Chatter

Maintenance Mode

None

 

42

Coupa

Coupa

Maintenance Mode

Coupa V2

 

43

Dropbox

Dropbox

Maintenance Mode

None

New connector on roadmap.

44EloquaEloqua (Soap)Maintenance ModeEloqua Bulk, Eloqua REST

45

Google API

Google API

Maintenance Mode

Google analytics

 

46

LinkedIn

LinkedIn

Maintenance Mode

None

New connector on roadmap.

47

Marketo

Marketo

Maintenance Mode

Marketo V3

 

48

Marketo

Marketo REST

Maintenance Mode

Marketo V3

 

49MemSQLMemSQLMaintenance ModeMemSQL V2Work with MemSQL for connector access

50

Microsoft Azure Blob Storage

Microsoft Azure Blob Storage V1

Maintenance Mode

Microsoft Azure Blob Storage V3

Consider building new and updating existing mappings to use Blob Storage V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

51

Microsoft Azure Blob Storage

Microsoft Azure Blob Storage V2

Maintenance Mode

Microsoft Azure Blob Storage V3

Consider building new and updating existing mappings to use Blob Storage V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

52

Microsoft Azure Cosmos DB SQL API

Microsoft Azure Document DB

Maintenance Mode

Microsoft Azure Cosmos DB SQL API

Consider building new and updating existing mappings to use Cosmos DB SQL API connector. Note that the Cosmos DB SQL API connector does not support DSS yet. Support for DSS equivalent functionality with the Cosmos DB SQL API connector is planned to be available in 1H 2020

53

Microsoft Azure Data Lake Store Gen1

Microsoft Azure Data Lake Store V1

Maintenance Mode

Microsoft Azure Data Lake Store V3

Consider building new and updating existing mappings to use ADLS V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

54

Microsoft Azure Data Lake Store Gen1

Microsoft Azure Data Lake Store V2

Maintenance Mode

Microsoft Azure Data Lake Store V3

Consider building new and updating existing mappings to use ADLS V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

55

Microsoft Azure SQL DW

Microsoft Azure SQL DW V1

Maintenance Mode

Microsoft Azure SQL Data Warehouse V3

Consider building new and updating existing mappings to use SQL DW V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

56

Microsoft Azure SQL DW

Microsoft Azure SQL Data Warehouse V2

Maintenance Mode

Microsoft Azure SQL Data Warehouse V3

Consider building new and updating existing mappings to use SQL DW V3 connector. Note that the V3 connector does not support DSS yet. Support for DSS equivalent functionality with the V3 connector is planned to be available in 1H 2020

57

Microsoft Dynamics AX

Microsoft Dynamics AX 2012

Maintenance Mode

Microsoft Dynamics AX 2012 V3

 

58

Microsoft Excel

Microsoft Excel v1

Maintenance Mode

Intelligent Structure Discovery

 

59Oracle CPQ (BigMachines)Oracle CPQ (BigMachines)Maintenance ModeREST V2

60

Oracle EBS

Oracle EBS 12.x (Cloud only)

Maintenance Mode

Use generic REST V2 or WS Connector

 

61

Oracle EBS

Oracle InterfaceTable

Maintenance Mode

Use generic REST V2 or WS Connector

 

62SAP AribaAriba HierMaintenance ModeAriba V2

63

SAP Concur

SAP Concur

Maintenance Mode

Concur V2

 

64

SAP SuccessFactors

SAP SuccessFactors SOAP

Maintenance Mode

SAP SuccessFactors Odata

 

65

TFS

TFS

Maintenance Mode

Generic REST V2 / WS Connector

 

66

TM2

TM2

Maintenance Mode

None

 

67

Twitter

Twitter

Maintenance Mode

None

New connector on roadmap.

68

WebServices - REST

REST

Maintenance Mode

REST V2

 

69

WebServices - SOAP

SOAP WebServices

Maintenance Mode

Webservices Consumer Transform

 

70

Webservices V2

Webservices V2

Maintenance Mode

Webservices Consumer Transform

 

71

Workday

Workday

Maintenance Mode

Workday V2

 

72

Zendesk

Zendesk

Maintenance Mode

Zendesk V2

 

73

Zuora

Zoura (SOAP)

Maintenance Mode

Zuora REST V2, Zuora AQuA

 

 

(Updated added MemSQL and Eloqua - 6/2019; added Ariba - 7/2019; added BigMachines - 11/2019)

The Informatica Intelligent Cloud Services (IICS) Winter 2019 release offers several new capabilities that address key data challenges that businesses are facing today. Highlights are listed below.

 

Data Integration

  • Data discovery in Cloud Data Integration with Enterprise Data Catalog (EDC) integration - Customers can now search and discover enterprise-wide metadata from within Data Integration, import connection & object metadata, and use that information to more easily create new or enrich existing mappings and tasks by connecting with an existing EDC installation.
  • “Smart match” recommendations for field mappings increases the frequency of field matches in mappings and tasks. Expanding on the existing automatch, smart match looks for common patterns in field names (prefixes, suffixes, abbreviations, etc.) based on six additional matchers and fuzzy match techniques for recommending field mappings.
  • Taskflows can be invoked via APIs for externalized scheduling and execution. With this enhancement, customers now can invoke taskflows on-demand via an API call and provide input parameters for the tasks it orchestrates, allowing customers to fully leverage Data Integration’s parameterization capabilities. Please refer to the Taskflow as a Service FAQ.
  • Taskflows have also been enhanced to allow them to embed other taskflows to promote reuse.
  • Change data capture has been expanded to include additional sources for DB2 on Linux, Unix, Windows, and iSeries (also known as AS400, i5/OS) platforms, which further enables near real-time changed data propagation capabilities.
  • Mass ingestion is extending connector support, adding Google Storage & Google Big Query as targets and HDFS as both a source and target. Additional enhancements expose CRUD-focused APIs.

 

API and Application Integration

  • Support for Kafka Messaging – Messaging is at the core of many publish-subscribe (Pub/Sub) based applications as a means of decoupling producers and consumers of data.  The addition of Kafka for application integration significantly increases current message-based Pub/Sub interactions between data and applications that today are fulfilled using JMS, AMQP, Amazon SNS/SQS, and Azure Service Bus based “topics.” The ability to bridge these message-based events with the Cloud Integration Hub Pub/Sub style of data propagation provides additional integration pattern options making Informatica unique in the flexibility and capabilities it provides for its customers.
  • JSON Web Token (JWT) based authentication – The API and Application Integration services now support JSON Web Token (JWT) based authentication, an open standard (RFC 7519) that defines a compact and self-contained way for securely transmitting information between API consumers and REST web services. This provides IICS users that use API Manager with another and more secure means of API authentication.
  • API grouping – To better manage the use of JWT tokens and associate their use to multiple API endpoints, a new API “application” grouping capability is being introduced in API Manager. This capability will provide API consumers with fewer tokens to deal with, and API producers will now more easily manage or revoke a consumer’s access to multiple APIs.
  • Japanese language support for the API and Application Integration services – In addition to Japanese language support for the Data Integration service, Japanese customers now have access to the API and Application Integration services user interface and documentation in Japanese.
  • REST and SOAP Service API-based “service connectors” – distributed via GitHub.

Today 55% of Application Integration customer’s connectivity needs are met using service connectors. A service connector allows customers to define REST (XML/JSON), JSON/RPC, or SOAP service integration using a simple web form, with no coding required. The Application Integration service takes care of the rest. If the service offers a WSDL or Swagger interface document, the service connector can be automatically generated by importing the interface document. By creating service connectors, customers can import and configure pre-built business and data service definitions as reusable assets that they can share and/or move from one environment to another. 

This capability, unique to Informatica, provides customers with unparalleled value. Service connectors avoid lock-in or an inability to make updates as you need them to take advantage of new capabilities or built-in extensibility that an API platform can offer. 

To provide this flexibility to customers and encourage community contribution by customers, partners, and other practitioners, Informatica is establishing a GitHub repository where it will publish the service connectors it has created and which it will share with its customers and partners. Customers and partners are free to use these definitions without restriction, including the rights to use, copy, modify, merge, publish, and distribute these under an MIT license. Informatica will also encourage contributions back to the community. Our goal is simple: drive innovation and reduce perceived barriers to adoption.

 

 

Integration Hub

  • Informatica has improved the search experience for Hub events and support for the CLOB data type on topics.

 

B2B Gateway

  • ICS B2B Gateway customers will be migrated to the IICS platform as part of the release upgrade and will benefit from all IICS platform capabilities.

 

Intelligent Structure Discovery

  • Intelligent Structure Discovery expanded its parsing capabilities to handle ORC format files and Excel multiple sheet files. The user can now design the structure model based on multiple sheet structures and then use the model at run time to parse Excel files in their entirety.
  • With R31, a Structure Parser transformation can be positioned mid-stream to enable a more flexible mapping usage and chaining. In addition, the Intelligent Structure Model detected datatypes are now propagated to the Structure Parser output ports.
  • The ISD design time user interface is enhanced with a "find" functionality which allows the user to search for a specific string in the discovered tree fields and get a list of results showing the path and visually correlated with the model representation. The user can also perform actions on multiple elements chosen from the result list such as include, exclude, replace, and even change of element type. The ability to perform actions on multiple elements significantly improves the usability and productivity.
  • A new vertical folder view mode will be available in R31 for handling complex hierarchy files.

 

IICS Platform

  • Common Explore productivity enhancements – Improved copy functionality with overwrite & rename conflict resolution options to copy assets within and across folders. “Created by” and “last updated by” attributes as columns for all asset types in the common Explore page.
  • Export/import capability for sub-organizations which enables asset migration across environments that use an organization hierarchy. More control and flexibility with enable/disable checksum validation options during export and import.
  • Improved export/import error logging along with the ability to access and download export/import logs through the UI and the API.
  • API to search, list, and filter assets in projects and folders using a variety of conditions such as timestamp, location, “last updated by,” and tags. This API can also be leveraged along with export APIs to export objects.
  • Improvements to the RunAJob utility – Support for projects and folders to invoke tasks by task name.
  • Usability improvements – Ability to copy table cell data in the common Explore page, Monitor service, and Administrator service for use in other user interfaces like search boxes and filter conditions for easier task completion.
  • Search capability for connections and job monitoring to quickly and easily find needed information.
  • Ability to enable and disable a service for agents in a Secure Agent group to effectively deploy workloads and efficiently utilize computing resources.
  • Secure Agent registration using tokens (instead of passwords) for increased security and enabling SAML single sign-on.

 

Operational Insights 

  • Operational Insights extends support to the on-premises Data Quality product, in addition to BDM and PowerCenter, with capabilities such as domain health, job run analytics, resource utilization, and alerts.
  • Click-through analytics journey from cross-domain to the individual job level and enhancements to job run analytics for on-premises products (PowerCenter, BDM). Plus, enhancements to job run analytics to report on data loaded and data processed.
  • Power Center & BDM infrastructure e-mail alert enhancements such as Secure Agent unavailability and Operational Insights data collection failures.

 

Connectivity Enhancements

New AWS Quickstart for Cloud Analytics Modernization, an end-to-end solution for self-service cloud analytics with Informatica (IICS, Enterprise Data Catalog), Tableau Server, and AWS Services.

Several new connectors and enhancements to existing connectors across ecosystems as listed below. New connectors introduced are highlighted in bold:

  • Azure: ADLS Gen 2 Preview, Azure DW V3, Azure Data Lake Store V3, Azure Blob V3 
  • Google: Google Cloud Storage V2, Google Analytics, Google Big Query V2, Google Big Query 
  • Amazon: Amazon S3 V2, Amazon Aurora, Amazon Redshift V2 
  • Salesforce: Salesforce Marketing Cloud (SFMC), SFDC (Sales and Service) 
  • SAP: SAP Connector, SAP HANA Cloud Platform (DB) 
  • Adobe: Adobe Cloud Platform 
  • Analytics: CDM Folders connector preview, Tableau V3, Tableau V2 
  • Databases: MySQL Relational, Hive, Greenplum, DashDB, Snowflake 
  • Tech: REST V2, WSconsumer, Complex File Processor 
  • Microsoft Apps: Microsoft SharePoint Online 
  • Oracle: Oracle Netsuite V1, Oracle Relational 

 

Summary of some of the connectivity enhancements are as follows:

AWS

  • Supporting file names longer than 250 characters with S3
  • Support for custom JDBC URL for Redshift
  • Support for ORC files with S3

Snowflake

  • Custom Query metadata fetching without having to run the query

Google

  • Custom Query Support for Google Big Query V2 connector
  • Pushdown support for Google Big Query thru ODBC
  • Google Analytics - Enhancement to fetch fields based on multiple Views IDs from GA
  • Google Big Query Mass Ingestion - Direct load Cloud Storage->Big Query

Azure

  • Preview of ADLS Gen2 connector: support create target, configurable escape character and text qualifier in R/W scenarios, create and rename directory, rename file, header-less files, support RBAC for all types of AAD Authentication, append data to an existing file, support parameterization
  • Azure DW V3: support TARGET NAME OVERRIDE and TARGET SCHEMA NAME OVERRIDE in the writer, support SOURCE NAME OVERRIDE and SOURCE SCHEMA OVERRIDE with the reader, support custom query and multiple objects in CMD and MCT

 

Microsoft Apps

  • Microsoft SharePoint Online: support for agents running on Linux

 

Analytics

  • Preview of CDM Folders connector: new connector, with the ability to write to ADLS Gen 2 in CDM format, and then access the data from Power BI as a dataflow
  • Tableau V2: upgrade connector to the latest Tableau SDK

Databases & DW

  • MySQL Relational: array insert support
  • Greenplum: native reader and writer

 

NetSuite V1: address 2-factor authentication

 

Salesforce

  • SFDC Sales, Service connector: support latest SFDC API
  • Salesforce Marketing Cloud SFMC: insert/update operation for “Non Contact Linked Data Extensions”

Dear Customer,

 

Today, we are excited to announce our acquisition of all assets of SynQ. SynQ, as you may know, was a boutique Informatica partner for many years and is a data integration platform that offers connectors to ServiceNow on Informatica Intelligent Cloud Services that your organization currently uses. This acquisition now means that Informatica will directly sell and support the connector. We believe this acquisition is positive for all our customers allowing Informatica to offer superior support and innovate faster in the ServiceNow cloud ecosystem.

 

  If you have any questions about this development, please contact our Global Support or your sales representative. For additional information, please refer to the attached FAQ

The Informatica Global Customer Support Team is excited to announce an all-new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data and so on. In these sessions, we will strive to provide you with as much technical details including new features and functionalities as possible, and where relevant, show you a demo or product walk-through as well.

 

Topic and Agenda

 

Topic: Cloud Webinar Series:  3 paths to revolutionize data integration

Date: Thursday, 11 October 2018

Time: 11:00 AM PDT/ 2:00 PM EDT

Duration: 1 Hour

 

About this Webinar:

 

Three focused, high-impact sessions with presentation and deep-dive demo debut on Oct. 11 at 11 am PDT:

  • Modernize your data warehouse, enable analytics, with next-gen cloud integration: This conversation and deep-dive demo explore how Informatica Cloud Data Integration lets you easily connect to any data source, quickly integrate and load trusted data to a cloud data warehouse, or deliver insights via self-service BI tools.
  • Integrate cloud and on-premises applications, no coding required: You’ve got Salesforce, Workday, and NetSuite in the cloud—but you also have SAP and Oracle on-premises. Learn how Informatica's next-generation Integration Platform as a Service (iPaaS) lets you quickly, easily synchronize data in real time in a hybrid environment.
  • 3Modernize legacy applications with API and data integration: Every new cloud application has to work with traditional on-premises applications. Learn how to use Informatica’s iPaaS solution to modernize your legacy environments for today’s cloud-first strategy.

 

Speakers:

 

Andrew Comstock, Director of Product Management, Informatica

Luc Clement, Senior Director of Product Management, Informatica

 

 

Join the webinar that address your needs, or sign up for all three sessions and take full advantage of your cloud potential—and the next generation of cloud integration.

 

-------------------------------------------------------

To register for this meeting

-------------------------------------------------------

 

Please find the details here: Cloud Webinar series: 3 paths to fast and agile cloud integration | Informatica US

 

You can also contact us at:

network@informatica.com

 

Regards,

MeetTheExperts Team

In this series of videos you will learn some essentials of Cloud Data Integration.

 

Getting StartedContent

Introducing Cloud Data Integration

 

This video is a quick introduction to Informatica Intelligent Cloud Data Integration.

Tasks and Mappings

 

Overview of the integration tasks and mappings to transform data using Cloud Data Integration

File-based Mass Ingestion

 

Using file-based mass ingestion for moving files from on-premise to Cloud storage like Amazon S3,Azure Blob

Advanced Taskflow

 

Using taskflows to orchestrate data  integration tasks

How to Download and Install a Secure Agent for IICS

 

This video shows you how to download and install a Secure Agent to use with Informatica Intelligent Cloud Services (IICS).



Here is an orientation video for the upcoming Informatica Cloud to Informatica Intelligent Cloud Services (IICS) migration process. The video provides an introduction to IICS for customers that are migrating from Informatica Cloud.

 

We will be migrating organizations between April and August. You will receive notification when YOUR organization(s) is going to be migrated and when your sandbox environment (pre-release) is available.

 

Video link (moved to YouTube so that it doesn't have to be downloaded):

 

Introducing Informatica Intelligent Cloud Services - YouTube

 

Full FAQ:

 

Informatica Intelligent Cloud Services Migration FAQ

Dear Customer,

The Informatica Global Customer Support Team is excited to announce an all new technical webinar and demo series – Meet the Experts, in partnership with our technical product experts and Product management. These technical sessions are designed to encourage interaction and knowledge gathering around some of our latest innovations and capabilities across Data Integration, Data Quality, Big Data etc. In these sessions, we will strive to provide you with as much technical details including new features and functionalities as possible, and where relevant, show you a demo or product walk-through as well.

Topic and Agenda

 

  • Meet the Experts –  Introduction to Informatica Intelligent Cloud Services
  • Date: March 13th 2018
  • Time: 8:00 AM PST
  • Duration: 1 Hour
  • What’s new in Cloud Data Integration
  • Increase your productivity with pre-defined templates
  • Build advanced orchestrations with new Taskflows
  • Leverage the SDLC capabilities of the platform for agile development.
  • Demo
  • The team will also cover everything that you need to know about migrating your current ICS orgs to IICS.

 

 

  Speakers:

 

  • Meenakshi Vasudevan
  • Dilip Poluru
  • Vivin Nath
  • Anand Peri

 

 

-----------------------------------------------------
To register for this meeting
-----------------------------------------------------
1. Go to
https://informatica-events.webex.com/informatica-events/j.php?RGID=rda4d5dab5df15af2228c1f2a3b50d88a
2. Register for the meeting.

Once the host approves your request, you will receive a confirmation email with instructions for joining the meeting.

To view in other time zones or languages, please click the link:
https://informatica-events.webex.com/informatica-events/j.php?RGID=r44607166cb690cc9522b298c0ce42491

-----------------------------------------------------
For assistance
-----------------------------------------------------
1. Go to
https://informatica-events.webex.com/informatica-events/mc
2. On the left navigation bar, click "Support".
You can contact me at:
meettheexperts@informatica.com