Connect your app to IBM Db2

1. 1

   Sign in to IBM Cloud, open your Db2 instance from the Resource list, and go to its 'Service credentials' tab to create a new credential.

   You need a username and password for your database, which you'll get from these credentials.

2. 2

   Copy the 'Deployment CRN' from your Db2 instance panel and note down the regional REST API endpoint (e.g., 'https://us-south.db2.saas.ibm.com').

   These are specific identifiers for your Db2 instance that Lovable needs to connect.

3. 3

   In Lovable, go to 'Connectors', select 'IBM Db2', and click 'Add connection' to choose 'App + chat connector'.

   This opens the form where you'll provide your Db2 connection details.

4. 4

   Enter the REST API endpoint, Deployment CRN, Userid (from your service credential's username), and Password into the 'Configure connection' section.

   These are the details Lovable uses to securely access your Db2 database.

5. 5

   Optionally, choose who can use this connection by sharing it with specific workspace members or the entire workspace under the 'Sharing' section.

   By default, the connection is private to you, but you might want others in your team to use it.

6. 6

   Click 'Connect' to finalize the setup.

   Lovable will verify your details and establish the connection to your Db2 instance.

Use IBM Db2 and build a dashboard that shows monthly revenue by region and product line.

SQL queries

Instructions written in a special language (Structured Query Language) that tell a database what information to find, change, or organize.

Schemas

The blueprint or structure of your database, defining how data is organized into tables and what kind of data each table holds.

Tables

A collection of related data organized in rows and columns, similar to a spreadsheet, within a database.

Deployment CRN

A unique identifier for your specific Db2 database instance within IBM Cloud, like a serial number for your database.

REST API endpoint

A specific web address that Lovable uses to communicate with your Db2 database over the internet.

• Using a service credential with administrator rights for your app, which could allow the app to accidentally change or delete important data. Instead, create a read-only database user.
• Putting your database password in a prompt, chat message, or your app's code, which makes it insecure. Only enter it in the Lovable connection form.
• Trying to connect to a Db2 server you run yourself, as this connector only works with managed Db2 instances in IBM Cloud.
• Expecting the connector to page through very large query results; it has a row limit, though it can export up to 100,000 rows as CSV.
• Expecting each app user to log into Db2 separately; each connection uses a single database user shared across all linked projects.