Manage data sources

With Pentaho Data Catalog, you can process data from file systems and relational databases.

To process data from these systems, Data Catalog establishes a data source definition. This data source stores the connection information to your sources of data, including their access URLs and user credentials. The number of data sources you can add is determined by your license agreement.

Note: Refer to the product release notes for the latest supported versions.

The following data sources are supported:

Type	Data source
File System	​HDFS data source​ ​NFS data source​ ​SMB/CIFS data source​ ​Local File System data source​
Relational Databases	​Amazon Redshift data source​ ​IBM Db2 data source​ ​Microsoft SQL Server data source​ ​MySQL data source​ ​Microsoft Access data source​ ​Oracle data source​ ​PostgreSQL data source​ ​SAP HANA data source​ ​Sybase data source​ ​Vertica data source​
NoSQL Databases	​DynamoDB data source​
Data Platforms	​Apache Iceberg data source Databricks data source
Object Stores	​AWS S3 data source1 ​Azure Blob Storage data source​ ​Google Cloud Storage data source​ ​HCP data source1​ ​OneDrive and SharePoint data source​ ​Snowflake data source
Others	​Okta as a data source​ ​Active Directory as a data source

If you encounter an error while connecting to a data source, refer to the data source provider's documentation for more information about the error.

---

¹ AWS S3, HCP, Minio, and VSP One data sources support Skip SSL validation when the data source uses a self-signed SSL certificate. Use this option only in non-production environments. To enable SSL validation, install user-provided SSL certificates into Data Catalog instead. For more information, see Install user-provided SSL certificates.