How to connect and make dashboard using SQLite database Build beautiful SQLite SQL reporting dashboards This article will address the following topics as well How to create SQLite dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with SQLite SQLite is an in-process library that implements a self-contained, serverless, zero-configuration, transactional … Read more
How to make dashboard using PostgreSQL database Create beautiful Postgresql reporting dashboards This article will address the following topics as well How to create PostgreSQL dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with PostgreSQL PostgreSQL is a powerful, open source object-relational database system. It has more than 15 years of … Read more
How to create dashboard for MySQL database Make beautiful MySQL SQL reporting dashboards This article will address the following topics as well How to create MySQL dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with MySQL MySQL is the most popular Open Source SQL database management system. Due to its … Read more
How to create dashboard with SQL Server database Build beautiful SQLserver SQL reporting dashboards This article will address the following topics as well How to create SQL Server dashboards ? How to build online reporting dashboards for your business? Easy Dashboard Reporting with SQL Server Microsoft SQL Server is a relational database management system developed by … Read more
CSV to MySQL – Advanced settings When you upload a CSV file, it is parsed and displays the default options as shown above. Seq ID : This is only for visual purpose and not used anywhere else. Source Column: This field is derived from the first row of the CSV file. The uploaded CSV file is … Read more
Please use the JDBC method to create PostgreSQL database connection
How to define SQL server database connection Select “SQL Server” from the left side panel. Enter all the fields on the right hand side. for e.g the following is the connection definition for a computer that has SQL server installed. You can use the IP address of the computer as the hostname.
How to create MySQL database connection From within the Dashboard Editor, go to InfoCaptor menu Action > Manage Data Source You can access the connection manager from the Data Tab “Create Connection” Select MySQL from the left panel and create a connection for MySQL Connection Handle : Give a good name so you can identify the … Read more
Here are the detailed steps to get connected with Firebird using JDBC and build dashboard with InfoCaptor. Assumptions Make sure Firebird is installed Make sure Firebird server is running Setup SYSDBA user and password (the default password is masterkey) 1. Download Firebird JDBC driver. For this tutorial we have used the 64bit drivers for windows … Read more
From SQL Query to Analysis InfoCaptor is extremely versatile dashboard application. It started initially just as “SQL Dashboard“. What do you mean by “SQL Dashboard”? This was the MVP (minimal viable product) for a Dashboard tool. The basic premise of the idea was that a developer can type any SQL query and produce the information. … Read more