Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Bolo.
Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
English
  • Data Ingestion and Replication
  • All Products

Table of Contents

Search

  1. Introducing Mass Ingestion
  2. Getting Started with Mass Ingestion
  3. Connectors and Connections
  4. Mass Ingestion Applications
  5. Mass Ingestion Databases
  6. Mass Ingestion Files
  7. Mass Ingestion Streaming
  8. Monitoring Mass Ingestion Jobs
  9. Asset Management
  10. Troubleshooting

Mass Ingestion

Mass Ingestion

Back Next

Mass Ingestion Databases connectors

Mass Ingestion Databases
 connectors

Before you begin defining connections for
database ingestion
 tasks, verify that the connectors for your source and target types are available in
Informatica Intelligent Cloud Services
.
The following table lists the connectors that
Mass Ingestion Databases
 requires to connect to a source or target that can be configured in a
database ingestion
 task:
Source or target type
Connector
Use for
Amazon Redshift
Amazon Redshift V2
Targets in initial load, incremental load, and initial and incremental load operations
Amazon S3
Amazon S3 V2
Targets in initial load and incremental load operations
Databricks Delta
Databricks Delta
Targets in initial load, incremental load, and initial and incremental load operations
Db2 for i
Db2 for i Database Ingestion
Sources in initial load, incremental load, and initial and incremental load operations
Db2 for Linux, UNIX, and Windows
Db2 for LUW Database Ingestion
Sources in initial load operations
Db2 for z/OS
Db2 for zOS Database Ingestion
Sources in initial load and incremental load operations
Flat file
No connector required
Targets in initial load and incremental load operations.
Google BigQuery
Google BigQuery V2
Targets in initial load, incremental load, and initial and incremental load operations
Google Cloud Storage
Google Cloud Storage V2
Targets in initial load and incremental load operations
Kafka, including Apache Kafka, Confluent Kafka, Amazon Managed Streaming for Apache Kafka, and Kafka-enabled Azure Event Hubs
Kafka
Targets in incremental load operations
Microsoft Azure Data Lake Storage Gen2
Microsoft Azure Data Lake Storage Gen2
Targets in initial load and incremental load operations
Microsoft Azure SQL Database
Microsoft SQL Server
Sources in initial load operations
Microsoft Azure Synapse Analytics
1
Microsoft Azure Synapse Analytics Database Ingestion
Targets in initial load, incremental load, and initial and incremental load operations
Microsoft SQL Server
Microsoft SQL Server
Sources in initial load, incremental load, and initial and incremental load operations
MongoDB
MongoDB Mass Ingestion
Sources in initial load and incremental load operations
MySQL, including RDS for MySQL
MySQL
Sources in initial load operations
Netezza
Netezza
Sources in initial load operations
Oracle, including RDS for Oracle
Oracle Database Ingestion
Sources in initial load, incremental load, and initial and incremental load operations
Targets in initial load, incremental load, and initial and incremental load operations
PostgreSQL, including RDS for PostgreSQL and Amazon Aurora PostgreSQL
PostgreSQL
Sources in initial load and incremental load operations
SAP HANA
SAP HANA Database Ingestion
Sources in initial load and incremental load operations
Snowflake
Snowflake Data Cloud Connector
Targets in initial load, incremental load, and initial and incremental load operations
Teradata Data Warehouse Appliance
Teradata
Sources in initial load operations
  1. For this target type, Mass Ingestion Databases uses Microsoft Azure SQL Data Lake Storage Gen2 to store staging files. Ensure that you have Microsoft Azure SQL Data Lake Storage Gen2 installed.
0 COMMENTS
We’d like to hear from you!