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








                                Zoho Desk Resources

                                • Desk Community Learning Series


                                • Digest


                                • Functions


                                • Meetups


                                • Kbase


                                • Resources


                                • Glossary


                                • Desk Marketplace


                                • MVP Corner


                                • Word of the Day



                                    Zoho Marketing Automation
                                            • 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. ____________________________________________________________________________________________________________


                                            Manage your brands on social media



                                                  Zoho TeamInbox Resources

                                                    Zoho DataPrep Resources



                                                      Zoho CRM Plus Resources

                                                        Zoho Books Resources


                                                          Zoho Subscriptions Resources

                                                            Zoho Projects Resources


                                                              Zoho Sprints Resources


                                                                Qntrl Resources


                                                                  Zoho Creator Resources


                                                                    Zoho WorkDrive Resources



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







                                                                            Design. Discuss. Deliver.

                                                                            Create visually engaging stories with Zoho Show.

                                                                            Get Started Now