Kloudio lets you connect your database in the Kloudio portal so that you can then use it to extract data to spreadsheets and/or write data back to the database.
What is a database connection?
The specification of your database that is needed by Kloudio in order to connect to it for extracting and updating data on your behalf to and from your spreadsheets.
Why do I need to create a database connection in Kloudio?
Kloudio needs a valid database connection in order to connect to your database, on your behalf, in a secure and authenticated manner to extract data into your Google Sheets. This step is a pre-requisite for you to download data onto Google Sheets or write data back to the database from Google Sheets using Kloudio.
STEP 1: Go to Kloudio Connections and Click the + to create a New Connection. You will see the above screen. Here is exactly where you tell Kloudio the details of your database that you'd like to extract data from
STEP 2: Type in the details of your database. If you don't have it, you can also ask your company's database administrator to create this and share the connection with you
- Give an easy to remember Connection Name ( e.g. Corporate Data )
- Choose your database type (eg. MySql)
- DB credentials: Enter your DB username and password
- Hostname: This is the database hostname
- Port: e.g. 3306
- Database name: eg. Finance
- Additional DB options such as SSL encryption and whether it's a Production instance
If your database is inside a firewall, please whitelist our IP addresses: 22.214.171.124 and 126.96.36.199. Depending on your hosting environment, the procedure to whitelist will vary. Please contact firstname.lastname@example.org if you have any questions regarding this.
After filling all fields, click Save. Kloudio will use these stored credentials to execute your configured Kloudio reports securely and send it to Google Sheets.
Congratulations! You have successfully created a connection in Kloudio. You are now ready to create your first report!