...
After logging into SprngyBI go to Dataset page from Data menu option. On Dataset screen click on '+ Dataset' button to add any dataset.
It gives PostgreSQL, Presto, MySQL and SQLite or from a list of other supported databases. Below example shows how to connect with Data Lake using presto.
To add a database, go to Database page from the Data menu option. On Database screen click on '+ Database' button to add any dataset.
...
Connecting with Data Lake
...
After selecting Presto, for step 2 it ask for the presto url and database name to connect. Check for the connection by clicking on the Add dataset button connect button, if it succeeds then save the database.
Connecting with RDBMS
Another way is to connect with RDBMS database stored in MySQL. Here select MySQL from the list of supported databases.
...
On Step 2 it will ask for required credentials and database name to connect to the database name, schema name and the table inside of that schema.RDBMS database. Once filled click on Connect button.
...
Now on step 3 there are some additional settings if you want to add else click on Finish button to connect the database. For now the database list is filtered to show only the hive and presto connections but you should be able to add dataset of all connections from Dataset page.
...
Add Dataset
To add a dataset, go to Dataset page from the Data menu option. On Dataset screen click on '+ Dataset' button to add any dataset.
...
Use ‘Sprngy' database to access any of the application data in SprngyBI. On clicking on 'ADD’ button the data for that particular module and entity will accessible in SprngyBI as a dataset.
Creating Charts
Now you can create any charts using this dataset. To create a chart either click on that newly created dataset or go to charts page from the top navigation and select the dataset along with the required chart type.
...
There are also sprngy dashboard which monitor the processing of data. You can use these dashboards to check on the workloads running, there success and failure, there time consumption and so on.
...
Query Editor
SprngyBI provides a query editor to perform ad-hoc analysis using SQL queries. Queries can be saved for future use and collaboration.
...