Sales and billing
Revenue by period, product, rep and region straight from system tables.
Databases
Dashboards from ODBC, with AI
If your system has an ODBC driver, it can be a Hubviz source. Pick the DSN configured on your computer and use the tables in AI-built dashboards.
7 days free · Cancel before the trial ends and pay nothing
How to connect: ODBC
-
Create the connection profile
Enter your ODBC access details in Hubviz Studio. The profile is saved for reuse in other projects.
-
Pick tables or write the query
Browse schemas, tables and views, or write the SQL. If you prefer, describe it in plain language and AI generates the query.
-
Ask for the dashboard
With the cube created, ask AI for the dashboard or build it in the visual editor and publish to Hubviz Web.
What you can do
- Explorer with schemas, tables, views, primary and foreign keys
- Custom query or direct table selection
- AI SQL generator based on the database structure
- Scheduled refresh with cron expressions
Finance
Payables, receivables, overdue accounts and cash flow.
Inventory and operations
Turnover, coverage and movement by unit.
Executive view
KPI cards compared with the previous period for leadership.
Frequently asked questions
Does Hubviz change data in ODBC?
No. Hubviz reads data for analysis. We recommend a database user with read-only permission.
Do I need to know SQL?
No. You can pick tables or describe the query in plain language for AI to generate the SQL.
What do I need to use ODBC?
Your system’s ODBC driver installed and a DSN configured on the computer running Hubviz Studio.
See also
SQL Server SQL Server queries and tables in dashboards. PostgreSQL PostgreSQL queries and tables in dashboards. MySQL MySQL queries and tables in dashboards. Oracle Oracle queries and tables in dashboards. Firebird Firebird queries and tables in dashboards. SAP HANA SAP HANA queries and tables in dashboards.
See all your company numbers in one place this week
You get 7 free days to connect your sources and build your first dashboards.