Placeholder

Customer Forum

BI tools POC - Export workbooks database, and imported to MySQL. Database description?

Simon Posted: 2018-06-18 09:19

I have exported my workbooks database as a single SQL file, and plan to import it to a MySQL host so I can use Power BI to prototype some BI dashboards. The MySQL database server is an up to date Ubuntu server.

The database extract SQL file is executed using the mysql command line as the database root user.

I need a description of the database, and the table relationships. Is that document available?
Tigya (Workbooks Online) Posted: Wed, 20.06.2018 - 08:14

Hi Simon,

 

Thank you for your query.

 

We have some information on our API documentation which you may find useful in understanding the description of the database and table relationships. We do not have any schema documents available for this and you would not be able to import an SQL database, you will require developer time to action this. We do currently have a Case open which was raised by one of your colleagues, all future communications regarding this will be directly on this Case.

 

Kind regards,

Tigya Thapa