Renta imports data from MySQL Database and saves them to these databases:
- Google BigQuery
- SQL Server
As an example, let us consider the integration of MySQL Database with the Google BigQuery database.
Select the integration type
At the first stage, select the type of integration. For instance, MySQL Database.
Select the account
Click on the Add button and sign in using the account from where you need to obtain the data.
You will see the sign-in window. Fill in the fields:
- The server address;
- Account password.
Set up the integration
You should set up the integration by these parameters.
- Specify the necessary database in the Database field.
- Specify the tables for export in the Tables field.
- Specify the time for daily update of data in the Update time field.
Specify the database
Open the Add button and select the type of database from the list of available ones. In this case this is BigQuery.
After you have selected the database, you will see the created projects in Google BigQuery.
Select the project that you want to use. The dataset called Renta_dataset will be created in Google BigQuery. The selected data will be exported there as a table.