BellaDati can be connected to SAP HANA in-memory Big Data database.
Connecting to HANA
From Data Source Connectors page select SAP HANA.
You must specify following parameters:
- host: IP address or domain name
Additional parameters can be specified by clicking on Add link in bottom left part of Connection parameters window.
There are two options how to query SAP HANA:
- Database Discovery
- SQL Query Window
Database Discovery is a visual editor for specifying database queries. To obtain data from the your database:
- Click the table you want to query. BellaDati includes all columns by default.
- Check columns you want to import. Use select/deselect all to quickly manipulate with columns.
SQL Query Window
For advanced users or queries, BellaDati offers SQL Query Window. Use Query Window to construct desired SQL commands.