IBM Db2 + Querri
Querri copies the Db2 tables and views you pick into its Library, so anyone on the team can ask about them in plain language and get answers, charts and reports.
Querri only reads from IBM Db2 and never changes your records. SOC 2 Type II, HIPAA and ISO 27001:2022 certified, and your data is never used to train a model.
What you can answer
In Db2 that answer means SQL against tables only a few people know, followed by an export to a spreadsheet. Querri reads those tables and keeps the measure as a KPI, defined once and charted the same way every time.
KPIsThe core system and the CRM rarely share a report, so reconciling them usually starts with two exports and a lookup formula. Connect both and Querri matches them in one question, listing the accounts each side is missing.
SalesforceA standing Db2 extract tends to wait in the IT queue every month. Querri can run the same question against the synced tables on a schedule and send the result to finance as a report.
Reports & automationWhat comes over
Querri copies this data into your Library on a schedule, next to every other system you connect, so one question can draw on all of it.
After the first load, each scheduled sync brings in only rows that are new or changed since the last one.
Querri reads from IBM Db2 and never creates, edits or deletes anything there. Every answer runs on Querri's own copy.
Querri's own sharing and row-level access decide who sees which rows, in chat, dashboards, Claude, ChatGPT and the API.
How to connect
Say "connect IBM Db2" or pick it from the connector catalog.
Enter the host, port, database name, user and password in the secure form, and turn on TLS for Db2 on Cloud, which uses port 50001. The Db2 driver is IBM-licensed, so someone in your organization uploads your licensed copy of IBM's ibm_db driver once before the first connection.
Pick the data you want and how often it refreshes, then approve the first load.
The data lands in your Library, ready for chat, dashboards and scheduled reports.
FAQ
Upload your licensed copy of IBM's ibm_db driver once for your organization, then enter the host, port, database name, user and password in the secure form. Db2 on Cloud needs TLS turned on and usually port 50001. Databases on a private network can connect through a VPN tunnel.
The tables and views in the schema you choose, or in the user's default schema if you leave it empty. You pick which ones to bring in. Db2's own catalog schemas, such as SYSIBM and SYSCAT, are hidden from the picker.
As often as you schedule it. A full refresh reloads each table daily, weekly or monthly. An incremental sync runs hourly, daily or weekly and brings in only rows past the last value of a cursor column you choose, such as a last-updated timestamp.
Db2 for Linux, UNIX and Windows, and Db2 on Cloud. One limit to know: the Db2 driver builds its connection string from your settings, so a user name, password or database name containing a semicolon is refused. Use an account whose credentials don't include one.
No. Querri only reads from IBM Db2. It never creates, edits or deletes records there, and every answer runs on Querri's own copy of the data.
Yes. Querri is SOC 2 Type II, HIPAA and ISO 27001:2022 certified, credentials are stored encrypted, and your data is never used to train a model.
Keep exploring
Connect IBM Db2, add the rest of your systems, and get answers your whole team can check.
