Use IBM Db2 in your Crisp app.
Run SQL on Db2 on Cloud.
Run SQL and browse schemas and tables in a Db2 on Cloud or Db2 Warehouse on Cloud database, with the service credentials from IBM Cloud.
What you need.
Create the keys in your IBM Db2 account and paste them in. Each one is saved under the name shown, and your app reads it by that name.
- REST API endpoint
DB2_API_URL- The regional endpoint for Db2 on Cloud, or the https_url of a Db2 Warehouse instance Get it
- Deployment CRN optional
DB2_DEPLOYMENT_CRN- cloud.ibm.com, Resource list, your instance. Needed with a regional endpoint, empty for a per-instance one
- User ID
DB2_USER- Service credentials, or a read-only user made in the Db2 console
- Password
DB2_PASSWORD- The password issued with that user ID
- Database optional
DB2_DATABASE- Usually BLUDB
How to connect.
-
Open your project, or start a new one from the dashboard.
-
Open the workspace menu and choose Connectors, then pick IBM Db2.
-
Paste the keys and save. Your preview restarts, and your app can use the service from then on.
Then ask for the feature
- “Show open orders from my Db2 database”
- “Export a Db2 report as CSV each morning”
What happens to your keys.
- Each key is saved as a private setting of your project, under the name shown above.
- The AI that builds your app sees only the names. It writes code that reads each key by name, and never the value.
- The values reach your preview and your published app, and never the chat, the code or the logs.
- Open Connectors in your project to replace a key or disconnect the service. Publish again so your live app uses the change.
Service names and logos belong to their owners; Crisp is not affiliated with them. A service changes its keys and pages now and then. Found something out of date? Tell us and we will correct it.
Ask for the feature, and Crisp builds it with IBM Db2.
Free plan with $3 of AI usage a month, no credit card. Pro is $20 a month. See pricing.
No credit card. Your code and data stay yours.