SAP Knowledge Base Article - Public

2326731 - Connecting to an External Database with Roambi Cloud

Symptom

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

Environment

Roambi Cloud

Resolution

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.

 

Keywords

KBA , BI-ROM-CLD-SRC , Roambi Cloud Service , BI-ROM-CLD-PUB-TAL , Roambi Cloud publishing clients - Talend , How To

Product

SAP Roambi Cloud all versions