OpenAI Setup Guide Lite
Follow our setup guide to connect OpenAI to Fivetran.
The OpenAI connector syncs data from OpenAI Platform and does not include data from ChatGPT.
Prerequisites
To connect OpenAI Platform to Fivetran, you need an OpenAI Platform account with the Owner role in the organization.
You need the Owner role only to create the API keys for the connection. Fivetran does not use the Owner role or its privileges to sync your data. For more information about role-based access control (RBAC) in OpenAI Platform, see OpenAI documentation.
Setup instructions
Create Admin API key
Fivetran uses an Admin API key to access and sync organization-level data, such as audit logs, usage, and users, from the Administration API.
Log in to your OpenAI Platform account.
In the top-left corner, click your project name and select Manage projects.
On the navigation menu, click Admin keys.
Click + Create new Admin key.
Enter a Name for the API key.
In the Permissions field, select Read only.
Click Create Admin key.
Make a note of the Admin API key. You will need it to configure Fivetran.
The Admin API key appears only once after you create it. Make sure you save the key before you close the dialog.
Create project-specific API key
Fivetran uses an API key to access and sync data, such as files, skills, batches, and evaluations, for a specific project. This API key grants access only to resources and data within that project. It does not grant access to organization-level data or to data from other projects in the same OpenAI organization.
In the OpenAI Platform dashboard, go to the project whose data you want to sync.
On the navigation menu, click API keys under Project.
Click + Create new secret key.
Enter a Name for the API key.
Verify whether the project whose data you want to sync is selected in the Project drop-down menu.
In the Permissions field, select Read only.
Click Create secret key.
Make a note of the API key. You will need it to configure Fivetran.
The API key appears only once after you create it. Make sure you save the key before you close the dialog.
Finish Fivetran configuration
- In the connection setup form, enter your Destination schema name.
- Enter the Admin key you created.
- Enter the API key you created for your project.
(Hybrid Deployment only) If your destination is configured for Hybrid Deployment, the Hybrid Deployment Agent associated with your destination is pre-selected for the connection. To assign a different agent, click Replace agent, select the agent you want to use, and click Use Agent.
- Click Save & Test. Fivetran will take it from here and sync your OpenAI Platform data.