The move will make it easier for non-techies to load data to their Redshift console.
The integration helps admins launch and operate Informatica Data Loader within their Amazon Redshift console and “easily copy data without having to install additional components or write code”, AWS promises. The loader can upload large volumes of data across many data formats, the organization said.
Informatica Intelligent Data Management Cloud (IDMC) is an AI-powered, metadata-driven platform that offers “comprehensive and cohesive cloud data management capabilities to discover, catalog, ingest, cleanse, integrate, govern, secure, prepare and master data”, according to an Amazon blog post.
Informatica Data Loader for Amazon Redshift, available on the AWS Management Console, is a zero-cost, serverless IDMC service that enables “frictionless data loading” to Amazon Redshift.
Easier access to third-party data
Informatica has also integrated its Cloud Data Marketplace with AWS Data Exchange. This, the organization says, will make it easier for users to access data from third-party sources.
The AWS Data Exchange is a repository of more than 3,000 data collection sets from more than 250 data providers available in a single, centralized interface. The Cloud Data Marketplace allows data from multiple sources to be organized into categories for browsing and ingestion by data consumers. There’s also a data asset registry for inventorying available datasets and built-in governance.
“It’s a way for any user to shop for data in a very governed way”, said Informatica Chief Executive Amit Walia, adding that Informatica is now the only vendor that packages both first- and third-party datasets in combination with AWS Data Exchange. Customers can access Informatica Data Loader directly from the Amazon Redshift console.
Techzine is attending AWS re:Invent this week. Keep an eye on the website for more. You can find the most important news in this overview.