Best Way to Pull Data into Excel Spreadsheet and Homegrown Applications

Jessica Monego

We are pretty new to the cloud (1yr now), We are looking for the best way to connect several Excel Docs, most pulling simple information like item costs fields, or job information. And a homegrown CRM application which is also just pulling data from Syteline but eventually would like to push data in as well.

Is there a simple way of doing either of these connections? I would love multiple examples of how all of you may be doing this for your businesses.

Thanks!

Jessica

Matthew Nye

Your use case will likely dictate the best approach, as there are a lot of different ways to accomplish this.

We use Application Engine to ingest external data the most. This gets the data into an Azure RDBMS thats accessible immediately to create reports (the most common need in our customers cases) using Application Studio.

AppEngine is a programming IDE so it does require a strong grasp of object-oriented programming constructs. With AppEngine we are able to schedule the process in ION to do incremental loads of the identified files. Additionally, we have created custom interfaces to allow users to manually load data, if thats a requirement

Hope this helps.