Sharing data with SQL Server

Sharing data with SQL Server

A client I am working for has a microsoft access 2010 database that is used for daily reporting and other project monitoring purposes. Currently it is single user. It has standing data but on a daily basis data is downloaded from Zoho creator and uploaded into this access database.
The task I am charged with is to move the data from the MS Access database into a cloud based SQL Server database on Azure and allow the users to continue to use their MS access front end  connected to the SQL Server database and seamlessly work as usual. On the other side I need to have a way to update this SQL server database with data from zoho either on demand or from a schedule running during the day.
I'm really new to using API calls and can't find anything that is simple enough to give me confidence in how to use it.
What I am looking for is the best way to get data into the SQL server database from zoho.
1. Should I be running code from SQL Server to pull records from zoho Creator using commands in SQL server via some API ( where would I find this and decent relevant examples on how to use it )
2. Should I be running deluge script from ZOHO and pushing/inserting records into the SQL Database?. (Again where would I find how to do this with relevant examples)
3. Should I rewrite the access application in SQL Server or Zoho creator?


      Zoho Campaigns Resources


        • Desk Community Learning Series


        • Digest


        • Functions


        • Meetups


        • Kbase


        • Resources


        • Glossary


        • Desk Marketplace


        • MVP Corner


        • Word of the Day


        • Ask the Experts


          • Sticky Posts

          • How to Add Users to your Organization in ZohoMail?

            A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________

          Zoho CRM Plus Resources

            Zoho Books Resources


              Zoho Subscriptions Resources

                Zoho Projects Resources


                  Zoho Sprints Resources


                    Zoho Orchestly Resources


                      Zoho Creator Resources


                        Zoho WorkDrive Resources



                          Zoho CRM Resources

                          • CRM Community Learning Series

                            CRM Community Learning Series


                          • Tips

                            Tips

                          • Functions

                            Functions

                          • Meetups

                            Meetups

                          • Kbase

                            Kbase

                          • Resources

                            Resources

                          • Digest

                            Digest

                          • CRM Marketplace

                            CRM Marketplace

                          • MVP Corner

                            MVP Corner




                            Zoho Writer Writer

                            Get Started. Write Away!

                            Writer is a powerful online word processor, designed for collaborative work.

                              Zoho CRM コンテンツ








                                ご検討中の方