Catalog Source Configuration > Source systems
  

Source systems

View the source systems, the connections to configure each source in Informatica Intelligent Cloud Services Administrator, and the capabilities for each source.
The following table shows the connections and capabilities for each source system that Metadata Command Center provides by default:
Source System
Connection
Incremental Metadata Extraction
Serverless Runtime Environment
Data Profiling
DQ Automation
Data Observability
Data Classification
Glossary Association
Advanced Programming Language Parsing
Connection-aware scan
Relationship Discovery
Amazon Athena
No
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Amazon DynamoDB using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Amazon Redshift V2
No
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Amazon S3 V2
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
Yes
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
Apache Cassandra using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Hive Connector
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Hive Connector
No
No
No
No
No
No
No
Yes
Not Applicable
No
Amazon Athena
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes (PySpark)
Yes
No
Databricks Delta
No
No
Yes
Yes
Yes
Yes
Yes
Yes (PySpark & SQL)
Yes
No
Databricks Delta
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
erwin Data Modeler File
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
erwin Data Modeler File
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
Not Applicable1
No
No
Yes
Note: Available for Local File System protocol.
Yes
Yes
Note: Available for Local File System protocol.
Yes
Yes
Not Applicable
Not Applicable
No
Google BigQuery V2
No
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
Yes
Google BigQuery V2
No
Yes
No
No
No
No
No
No
Yes
No
Google Cloud Storage V2
No
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
Yes
Not Applicable1
No
Yes
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
No
Greenplum
No
No
No
No
No
No
No
Yes
Not Applicable
No
Hadoop Files V2
No
No
Yes
Yes
No
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
No
Db2 for LUW Database Ingestion
No
No
Yes
Yes
No
Yes
Yes
Yes
Not Applicable
No
Db2 for LUW Database Ingestion
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes
Yes
No
Db2 for zOS Database Ingestion
No
No
Yes
Yes
No
Yes
Yes
Yes
Not Applicable
No
IBM Db2 for z/OS using JDBC5
JDBC V2
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Not Applicable
No
No
No
No
No
No
No
Yes
Yes
No
Netezza
No
No
No
No
No
Yes
Yes
Yes
Not Applicable
Yes
IBM Netezza using JDBC5
JDBC V2
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
NetSuite using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable1
No
No
Not Applicable
No Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
Not Applicable1
No
No
No
No
No
No
No
No
Yes
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Kafka
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
MySQL
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Marketo using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Microsoft Azure Analysis Services
No
No
No
No
No
No
No
Not Applicable
Yes
No
Microsoft Azure Blob Storage V3
Yes
Yes
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
Microsoft Azure Cosmos DB using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable1
No
Yes
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Microsoft Azure Data Lake Storage Gen2
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
Yes
SQL Server
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Microsoft Azure Synapse SQL
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Microsoft SQL Server
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Microsoft Azure Synapse Analytics
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes (PySpark & SQL)
Yes
No
Microsoft Azure Synapse SQL
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Microsoft Dynamics CRM using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Microsoft Fabric Data Warehouse
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Yes
Microsoft Fabric Lakehouse
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
No
Microsoft Fabric OneLake
No
No
Yes
Note: Available for delimited files.
Yes
Yes
Yes
Yes
Not Applicable
Not applicable
No
Not Applicable1
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
Microsoft Power BI
No
Yes
Not Applicable
No Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Not Applicable1
No
Yes
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
Microsoft SharePoint Online
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
SQL Server
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
SQL Server
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Not Applicable¹
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Microsoft SQL Server
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes
Yes
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
No
MongoDB using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
MySQL
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Oracle
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
No
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes
Yes
No
Oracle
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
Yes
Oracle
No
No
No
No
No
No
No
Not Applicable
Yes
No
Oracle
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Yes
Yes
No
PostgreSQL
No
No
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
Yes
Not Applicable1
No
Yes
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
No
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
Yes
Salesforce
No
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
Yes
Not Applicable
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
No
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
No
No
SAP BW
Yes
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
SAP BW
Yes
No
Yes
Yes
No
Yes
Yes
Not Applicable
Not Applicable
No
SAP OData V4
No
Not Applicable
No
No
No
No
No
No
Not Applicable
No
SAP Bapi
SAP Table. For data profiling
Yes
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
SAP HANA
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Not Applicable
No
Not Applicable1
No
No
No
No
No
Yes
Yes
Not applicable
Not applicable
No
SuccessFactors OData
No
Not applicable
No
No
No
No
No
No
Not applicable
No
SAP SuccessFactors using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Not Applicable
No
No
No
No
No
No
No
Yes
Not Applicable
No
Advanced SFTP V2
No
No
No
No
No
Yes
Yes
Not Applicable
Not Applicable
No
SingleStore using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Snowflake Data Cloud
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Not Applicable
Yes
Snowflake Data Cloud
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Sybase ASE using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Sybase IQ using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Tableau V3
No
No
Not Applicable
Not Applicable
Not Applicable
Yes
Yes
Not Applicable
Yes
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
No
No
Teradata
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Teradata
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
Teradata
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Teradata
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Teradata
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
Yes
No
Not Applicable1
No
No
Not Applicable
Not Applicable
Not Applicable
No
No
Not Applicable
No
No
Workday using JDBC5
JDBC V2
No
No
Yes
Yes
Yes
Yes
Yes
Not Applicable
Not Applicable
No
1 For these catalog sources, you do not need to configure a connection in the Informatica Intelligent Cloud Services Administrator.
2 You can procure the source-specific JDBC drivers to perform data profiling and quality for these source systems using the JDBC catalog source. Note that JDBC drivers are not bundled as part of Informatica Intelligent Cloud Services. You can purchase the driver directly from the vendor or download it from the CData third-party website.
3 Effective in the February 2023 release, the Databricks Delta Lake catalog source is deprecated. Informatica intends to drop support for the Databricks Delta Lake catalog source in a future release. If you want to extract metadata from the Databricks Delta Lake source system, Informatica recommends that you use the Databricks catalog source.
4 For these catalog sources, you can only use Secure Agents installed on Windows machines.
5 To connect to these source systems and run metadata extraction, data profiling, and data quality jobs, you can configure a secrets manager for your organization. Use AWS Secrets Manager or Azure Key Vault to store and retrieve sensitive credentials.
Note: Metadata extraction with Secure Agent is supported for all source systems.
For information about configuring a connection in Administrator, see Connections in the Cloud Common Services help.