Accessing parse.com and scriptDB noSQL databases from Excel

I figured it would be pretty nice to be able use one of the cloud based noSQL databases directly from VBA, so that I could share data easily between various platforms. On Excel Liberation , I recently released a few APIs to open up cloud based noSQL databases to VBA access to make this possible.

In this post, I’m going to use the VBA APIs for Google Apps Script ScriptDB and Parse.com to copy data between the two databases using VBA as the agent.

The APIs have very similar interfaces, so the coding is exactly the same once the connection has been made.

Here’s the main procedure.

The test will be to copy an entire class from parse.com to scriptDb and back again, and do a few counts and queries to compare before and after.

 

And here’s the common copy procedure – which remains oblivious to the flavor of data base being used.

 

And here’s the result of the query – they match

 

Here’s a couple of primer decks to get some background on how all this works.

For more like this see Excel Liberation.

About brucemcp 223 Articles
I am a Google Developer Expert and decided to investigate Google Apps Script in my spare time. The more I investigated the more content I created so this site is extremely rich. Now, in 2019, a lot of things have disappeared or don’t work anymore due to Google having retired some stuff. I am however leaving things as is and where I came across some deprecated stuff, I have indicated it. I decided to write a book about it and to also create videos to teach developers who want to learn Google Apps Script. If you find the material contained in this site useful, you can support me by buying my books and or videos.

Be the first to comment

Leave a Reply

Your email address will not be published.


*


2 × one =