Export data to cloud databases

Export data to cloud databases

You can export data to the following cloud databases.
  1. Amazon RDS - MySQL
  2. Amazon RDS - MS SQL Server
  3. Amazon RDS - Oracle
  4. Amazon RDS - PostgreSQL
  5. Amazon RDS - Maria DB
  6. Amazon RDS - Amazon Aurora MySQL
  7. Amazon RDS - Amazon Aurora PostgreSQL
  8. Amazon Redshift
  9. Amazon Athena
  10. Microsoft Azure-MySQL
  11. Microsoft Azure - PostgreSQL
  12. Microsoft Azure - Maria DB
  13. Microsoft Azure - SQL Database
  14. Microsoft Azure - SQL Data Warehouse
  15. Google Cloud SQL - MySQL
  16. Google Cloud SQL - PostgreSQL
  17. Snowflake
  18. Oracle Cloud
  19. IBM Cloud - DB2
  20. Heroku PostgreSQL
  21. Rackspace Cloud - MySQL
  22. Rackspace Cloud - Maria DB
  23. Panoply
  24. MySQL
  25. MS SQL Server
  26. Oracle
  27. PostgreSQL
  28. Maria DB
  29. MemSQL
  30. DB2

To export data to cloud databases

1. Click the Export now option from the Export menu in the Studio page. 

2. From the side pane, choose Cloud databases.

3. If your data contains columns with personal data, you can choose which columns need to be exported from the PII columns section.

4. Select your database service name, database type, enter the values in the required fields such as endpoint and  database name to configure the cloud database connection.

5. You can also provide a username and password if the database connection is to be authenticated.

6. Enter a unique connection name.

7. You can also select the Use SSL check box if your database server has been setup to serve encrypted data through SSL.

8. Click the Connect button.

9. Once you have successfully connected to your cloud database, you can choose how and where to export the data.

10. Choose Existing table if you want to export data to an existing table and select one from the list of tables available in the database. 

11. If you want to create a new table select the New table option and enter a table name in the field below. 

12. If you select the existing table option, there are two ways in which you can choose how to add the new rows to the table. 
  1. If the new rows are to be added to the table, choose Append.
  2. If the newly added rows are to replace the existing rows, select Overwrite from the dropdown.
13. Click Export. 

14. Once the export is complete you can choose to schedule this export by clicking the Schedule configuration> link below.

    Redefine the way you work
    with Zoho Workplace

      Zoho DataPrep Personalized Demo

      If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.

      Zoho CRM Training

        Create, share, and deliver

        beautiful slides from anywhere.

        Get Started Now

          Get started with Zoho Sign

          in a few quick steps!

          Download Help Guide

                    Explore our  Pricing Plans

                      Secure your business
                      communication with Zoho Mail

                      Mail on the move with
                      Zoho Mail mobile application

                        Stay on top of your schedule
                        at all times

                        Carry your calendar with you
                        Anytime, anywhere

                                Zoho Sign Resources

                                  Sign, Paperless!

                                  Sign and send business documents on the go!

                                  Get Started Now

                                      Zoho SalesIQ Resources

                                          Zoho TeamInbox Resources

                                                  Zoho DataPrep Resources

                                                    Zoho DataPrep Demo

                                                    Get a personalized demo or POC

                                                    REGISTER NOW

                                                      Design. Discuss. Deliver.

                                                      Create visually engaging stories with Zoho Show.

                                                      Get Started Now

                                                                            • Related Articles

                                                                            • Export data to Google BigQuery [Private Beta]

                                                                              Zoho DataPrep supports exporting data to Google BigQuery. BigQuery is a fully managed enterprise data warehouse that helps you manage organization data. To export data to Google BigQuery 1. Click the Export now option from the Export menu in the ...
                                                                            • Import data from cloud storage services

                                                                              DataPrep supports import from the following cloud storage services. Google Drive One Drive Box Storage Dropbox Zoho WorkDrive Amazon S3 To import data from a cloud storage service 1. Click Cloud Storage in the Choose a data source box. 2. Choose one ...
                                                                            • Import data from cloud databases

                                                                              You can import data from the following cloud databases:  Amazon RDS - MySQL Amazon RDS - MS SQL Server Amazon RDS - Oracle Amazon RDS - PostgreSQL Amazon RDS - Maria DB Amazon RDS - Amazon Aurora MySQL Amazon RDS - Amazon Aurora PostgreSQL Amazon ...
                                                                            • Import data using saved data connections

                                                                              DataPrep saves your data connections to avoid hassles in keying them often. To access your saved data connections  1. Click Saved data connections from the Choose a data source box while creating a new dataset.  2. Manage your saved data connections ...
                                                                            • Scheduling data export

                                                                              You can schedule data export using different export configurations in DataPrep. To schedule data export Click Export from the top bar in the Studio page and select Schedule export.               2. Click the New schedule button to create a new ...
                                                                            Wherever you are is as good as
                                                                            your workplace



                                                                              Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                              Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                              Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                              CRM Tips

                                                                              Make the most of Zoho CRM with these useful tips.

                                                                                Zoho Show Resources