Import data from Progress OpenEdge | Zoho Analytics On-Premise

Import data from Progress OpenEdge


If you have your data stored in Progress OpenEdge local database, you can easily import the data into Zoho Analytics for advanced reporting and analysis. 

Data Import

1. How do I import data from the Progress OpenEdge database into Zoho Analytics?

2. How do I edit the import setup?


3. How long does it take for the data to be imported into Zoho Analytics?

After setting up data import from your local database, you might have to wait some time for the initial fetch to happen. Depending on the amount of data in your application, the reports and dashboards might take up to 5 minutes to display all the metrics. If you access the workspace before the initial fetch is complete, it will not display any data.

4. Will the foreign keys defined between the tables in the local database be linked in Zoho Analytics as well? 

When importing multiple tables, the foreign keys defined between the tables in the local database will be linked in Zoho Analytics using lookup columns. However, if you import one table at a time, the foreign keys will not be defined. In such cases, you can manually link the tables in Zoho Analytics using the lookup column functionality. To learn more about lookup columns, click here

5. Is it possible to change the data type of the columns imported into Zoho Analytics? 

Yes. To learn more about changing the column type in Zoho Analytics, click here
Note: While changing the column's data type in Zoho Analytics, ensure that it is compatible with the column's data type in the local database, for successful data synchronization. 

6. How do I schedule data import?

Follow the steps below to schedule data import for an existing table in Zoho Analytics. 

  • Select the Data Sources option from the side panel, and navigate to the required Progress OpenEdge data source.

  • Click the Sync Settings button.

  • Select the required schedule interval from the Repeat every drop down. 

  • Specify the number of consecutive import failure after which you are to be notified in the Notify me after every 'N' Sync Failure (s) section.

  • Click Save. The data from your Progress OpenEdge database will be imported into Zoho Analytics in the specified intervals. 

You can also schedule the import during the initial import. Refer this presentation to know more.

7. How do I get notified of import failures?

You can choose to be notified of consecutive import failures, in case it occurs, while setting up data schedules. To do this, 

  • Select the Data Sources option from the side panel, and navigate to the required Progress OpenEdge data source.

  • Click the Sync Settings button.

  • Specify the number of consecutive import failure after which you are to be notified using the Notify me after every 'N' Sync Failure (s) section.

You can also set up notifications of import failures during the initial data import. Refer this presentation to know more.

8. Can I import data from the local database into an existing workspace in Zoho Analytics?

Yes. Follow the below steps to import data into an existing workspace:

  • Open the required workspace. Click Create from the side panel, and select the New Table / Import Data option. 

  • Click the Local Databases tile, and follow the steps detailed in this presentation

9. Can I synchronize data from the local database instantly?

Yes. Follow the steps below to do this.

  • Open the required workspace, and click the Data Sources tab from the side panel.

  • Click the Sync Now link.

10. How do I resolve synchronization failure?

To resolve synchronization failure, you need to understand the reason behind the failure. To do this, 

  • Click the Data Sources button from the side panel, and navigate to the required data source. 

  • Click the View Last Import Details icon that appears on mouse over the listed tables. This opens the Import Details page, which provides detailed insight on the reason for the synchronization failure.

You can also view the Import Details page by opening the required table, and selecting the Import Data -> Last Import Details option.

11. How do I remove a data source?

To remove the setup,

  • Click the Data Sources button from the side panel, and navigate to the required data source. 

  • Click the Settings icon that appears on mouse over the data source's name, and select Remove Data Source

Note: Removing the data source does not delete the corresponding tables and reports from Zoho Analytics. However, further synchronization cannot be carried out. 


    Zoho CRM Training Programs

    Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.

    Zoho CRM Training
      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


            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION










                                    You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.




                                        Manage your brands on social media

                                          Zoho Desk Resources

                                          • Desk Community Learning Series


                                          • Digest


                                          • Functions


                                          • Meetups


                                          • Kbase


                                          • Resources


                                          • Glossary


                                          • Desk Marketplace


                                          • MVP Corner


                                          • Word of the Day


                                            Zoho Marketing Automation

                                              Zoho Sheet Resources

                                               

                                                  Zoho Forms Resources


                                                    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 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

                                                                                                      • How to enable Progress OpenEdge DB connection

                                                                                                        Steps to include Progress OpenEdge DB in our local DB import list: 1. Download and install OpenEdge JDBC driver from https://www.progress.com/jdbc/openedge in Analytics installed server. (It is a paid driver. No free drivers are available) 2. From ...
                                                                                                      • Local or cloud db sync gets stuck in in-progress state

                                                                                                        Note:      This KB is specific for the sync issue with the below log traces. Log traces: [13:58:01:141]|[12-03-2019]|[SYSERR]|[INFO]|[118]:  ...
                                                                                                      • Import from Local Databases

                                                                                                        Zoho Analytics allows you to import data stored in different local databases such as MySQL, SQL Server, etc for advanced reporting and analysis. You can easily setup data import from these local databases using the simple setup wizard. Click here to ...
                                                                                                      • Import data from files

                                                                                                        If you have data stored in local drives in tabular file formats such as CSV, Excel, JSON, etc., you can easily import them into Zoho Analytics. Zoho Analytics offers easy import and copy-paste options of such data to jump start your reporting and ...
                                                                                                      • Import data from PostgreSQL

                                                                                                        If you have your data stored in PostgreSQL local database, then you can easily import your data into Zoho Analytics for reporting & analysis.  Data Import 1. How do I import data from the PostgreSQL local database? 2. How can I edit the setup? You ...
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace

                                                                                                          Resources

                                                                                                          Videos

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



                                                                                                          eBooks

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



                                                                                                          Webinars

                                                                                                          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