How Airbyte Works
About the source and destination
Exchange Rates Api
MySQL Destination
Sync with Airbyte
Sync Manually
What sets Airbyte Apart
Modern GenAI Workflows
Move Large Volumes, Fast
An Extensible Open-Source Standard
Full Control & Security
Fully Featured & Integrated
Enterprise Support with SLAs
Used by tens of thousands of developers, Exchange Rates API provides accurate and reliable currency data instantly through its free, simple-to-use API interface. With more than 10 years of exceptional API uptime and support, developers trust Exchange Rates API to provide fast and accurate conversion rates for 160 different currencies as well as essential stock market data in JSON format. They have worked hard to achieve their mission of building a remarkably hardware efficient and reliable currency converter API.
MySQL is an SQL (Structured Query Language)-based open-source database management system. An application with many uses, it offers a variety of products, from free MySQL downloads of the most recent iteration to support packages with full service support at the enterprise level. The MySQL platform, while most often used as a web database, also supports e-commerce and data warehousing applications, and more.
1. Go to the Airbyte dashboard and click on "Sources" on the left-hand side of the screen.
2. Click on the "Create a new source" button and select "Exchange Rates API" from the list of available connectors.
3. Enter a name for your source and click on "Next".
4. Enter your Exchange Rates API access key in the "API Key" field.
5. Select the base currency you want to use for your exchange rates in the "Base Currency" field.
6. Choose the frequency at which you want to update your exchange rates in the "Sync Frequency" field.
7. Click on "Test" to ensure that your credentials are correct and that the connection is successful.
8. If the test is successful, click on "Create" to save your source and start syncing your exchange rates data.
Note: You can also customize your source settings by selecting the tables you want to sync, setting up incremental sync, and adding filters to your data.
1. First, you need to have a MySQL database set up and running. Ensure that you have the necessary credentials to access the database.
2. Log in to your Airbyte account and navigate to the "Destinations" tab.
3. Click on the "Add Destination" button and select "MySQL" from the list of available connectors.
4. Enter the necessary details such as the host, port, username, password, and database name. Ensure that the details are accurate and match the credentials you have for your MySQL database.
5. Test the connection to ensure that Airbyte can successfully connect to your MySQL database. If the connection is successful, you will receive a confirmation message.
6. Once the connection is established, you can configure the settings for your MySQL destination connector. You can choose to enable or disable certain features such as SSL encryption, bulk loading, and more.
7. You can also set up the schema mapping for your MySQL database. This involves mapping the fields from your source data to the corresponding fields in your MySQL database.
8. Once you have configured the settings and schema mapping, you can start syncing data from your source to your MySQL database. You can choose to run the sync manually or set up a schedule for automatic syncing.
9. Monitor the sync process to ensure that data is being transferred accurately and efficiently. You can view the sync logs and troubleshoot any issues that may arise.
10. Congratulations! You have successfully connected your MySQL destination connector on Airbyte and can now start syncing data from your source to your MySQL database.
With Airbyte, creating data pipelines take minutes, and the data integration possibilities are endless. Airbyte supports the largest catalog of API tools, databases, and files, among other sources. Airbyte's connectors are open-source, so you can add any custom objects to the connector, or even build a new connector from scratch without any local dev environment or any data engineer within 10 minutes with the no-code connector builder.
We look forward to seeing you make use of it! We invite you to join the conversation on our community Slack Channel, or sign up for our newsletter. You should also check out other Airbyte tutorials, and Airbyte’s content hub!
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey:
Ready to get started?
Frequently Asked Questions
Exchange Rates API provides access to various types of data related to currency exchange rates. The API offers real-time and historical exchange rates for over 170 currencies, including cryptocurrencies. The following are the categories of data that the Exchange Rates API provides:
• Real-time exchange rates: The API provides real-time exchange rates for various currencies, which are updated every minute.
• Historical exchange rates: The API offers historical exchange rates for up to 10 years, allowing users to analyze trends and patterns in currency exchange rates.
• Currency conversion: The API allows users to convert one currency to another using the latest exchange rates.
• Time-series data: The API provides time-series data for exchange rates, allowing users to track changes in exchange rates over time.
• Currency metadata: The API provides metadata for various currencies, including their names, symbols, and ISO codes.
• Cryptocurrency data: The API provides real-time exchange rates for various cryptocurrencies, including Bitcoin, Ethereum, and Litecoin.
Overall, the Exchange Rates API provides a comprehensive set of data related to currency exchange rates, making it a valuable resource for businesses and individuals who need to track currency exchange rates.
What should you do next?
Hope you enjoyed the reading. Here are the 3 ways we can help you in your data journey: