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 Profiling
  • All Products

Table of Contents

Search

  1. Preface
  2. Data Profiling
  3. Profiles
  4. Profile results
  5. Tuning data profiling task performance
  6. Troubleshooting

Data Profiling

Data Profiling

Back Next

Create connections

Create connections

When you create a data profiling task, you need a connection to the source object. You can create connections in Administrator.
The following table lists the connections and the source objects that Data Profiling supports:
Connections
Supported source object
Amazon Athena
Amazon Athena
Amazon Redshift V2
Amazon Redshift
Amazon S3 v2
Amazon S3
Azure Data Lake Store Gen2
Azure Data Lake Store
Flat file
Flat file
Databricks Delta
Delta Tables
External Tables in Delta format. Also supports Databricks Unity Catalog.
Google BigQuery V2
Google BigQuery
Google Cloud Storage V2
Google Cloud Storage
JDBC V2
Azure SQL Database
PostgreSQL
MariaDB
Applicable for the data sources that are not supported with native driver and have a compliant Type 4 JDBC driver.
Mapplet
Source mapplets
Microsoft Azure Synapse SQL
Azure Synapse SQL
Microsoft SQL Server
Microsoft SQL Server
Azure SQL Database
ODBC
Applicable for the data sources that are not supported with native driver and have a compliant ODBC driver.
Oracle
Oracle
Oracle Cloud Object Storage
Oracle Cloud Object Storage
Salesforce
Salesforce Sales Cloud
Salesforce Service Cloud
Applications on Force.com
Salesforce Verticals which include Salesforce Health Cloud and Salesforce Financial Cloud.
SAP BW Reader
SAP BW
SAP Table
SAP ERP and SAP S/4 HANA
Snowflake Data Cloud
Snowflake Data Cloud
You can run a profile on Databricks Delta tables using an ODBC driver. You can download the Databricks ODBC driver here: https://databricks.com/spark/odbc-drivers-download. For more information about how to run a profile on Databricks Delta tables using Azure Databricks with an ODBC connection, see the Informatica How-To-Library article:
How to run a profile on Databricks Delta tables using Azure Databricks with ODBC connection
.
For Databricks Delta profiling tasks, Informatica recommends that you use the Databricks Delta connector rather than the ODBC connector.
For more information about creating connections, see Getting Started and Connections.
0 COMMENTS
We’d like to hear from you!