# Compatible data sources to enable an API

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

The API functionality is only compatible with datasets created from specific connection types, databases types, and dataset types. Your dataset must fulfill these three conditions in order to enable an API.

## Compatible connections

You can only enable an API for datasets created from a JDBC connection.

## Compatible databases

When creating a JDBC connection, you can select various databases as source to create a dataset. You should be able to enable an API on any of them, but the ones tested and validated by Talend are the following:

* MariaDB
* Microsoft SQL Server
* MySQL
* Oracle
* PostgreSQL
* Snowflake

Information noteNote: If you encounter any issue with a database type, contact your Qlik support representative.

## Compatible datasets types

After choosing a database type, you need to select how you want to retrieve the actual data to import in the form of a dataset. APIs can be enabled on dataset created via the following methods:

* Table name
* Query

Information noteNote: Table streams are not supported