Database Access FAQs

General

Where is this database located? Who all have access to it?

This database is located in the Amazon Web Services (AWS) cloud in Singapore. We create a separate database for each customer and only that customer has access to it. This data can only be access from computers that have been specifically authorized to access it.

Can I create my own tables in this database?

This database contains only your data and you have full access rights to it. You can choose to add new tables, run queries or do any other analysis that you would like to do

Can I do something to damage the data?

The database contains a set of tables that are managed by Canopy. These tables are synced once a day to our main database. In case you inadvertently damage or delete any of the tables, Canopy will repair the damage automatically next day. Of course this does not apply to any tables that you created

Technology

Can I connect to this database directly from Microsoft Excel?

Yes. That is not a problem at all. Enclosed is a short Youtube video. Please contact customer support in case of any issues

Can I connect to this database using Python, C# and other programming languages?

Yes of course. Please contact customer support in case of any issues