SAP Knowledge Base Article - Public

2326731 - Connecting to an External Database with Roambi Cloud


How can I connect to an external database like MySQL, SQL SERVER, etc. to Roambi Cloud?


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


SAP Roambi Cloud all versions