How can I connect to an external database like MySQL, SQL SERVER, etc. to Roambi Cloud?
This is possible by utilizing Roambi's API to automatically send data from your Database into the Roambi Cloud. Roambi Business will accept the following source file-types, so it would require extracting the data in this format prior to sending it to Roambi via the API:
- CSV Files
- HTML Tables
- Microsoft Excel Documents
- TXT Files
This method is commonly known as an "ETL" (extract, transform, load) process. If you are looking to easily automate this process in Roambi business, you can use a Roambi Automation Tool such as Talend which is a comprehensive ETL application.
KBA , BI-ROM-CLD-SRC , Roambi Cloud Service , BI-ROM-CLD-PUB-TAL , Roambi Cloud publishing clients - Talend , How To