Bubble


Bubble


This page outlines the steps to connect Bubble to the CData Connect Cloud Virtual SQL Server API.

Prerequisites

Before you connect, you must first do the following:

  • Connect a data source to your CData Connect Cloud account. See Connections for more information.
  • Generate a Personal Access Token (PAT) on the Settings page. Copy this down, as it acts as your password during authentication.

Connecting to CData Connect Cloud

To establish a connection from Bubble to the CData Connect Cloud Virtual SQL Server API, follow these steps.

  1. Log in to Bubble.

  2. On the left hand menu, click Plugins.

  3. Click Add plugins.

  4. Search for “SQL Database Connector” and click Install.

  5. Once it is installed, it is available to use as shown below. Click Add a new connection.

  6. Enter the connection settings.

    • Connection name—enter a name for the connection to CData Connect Cloud.
    • Database type—select Microsoft SQL.
    • Connection string—enter the SQL database connection string. This string includes a username and password in a format like sql://[Username]:[Password]@tds.cdata.com:14333/. Enter the following settings into this string.
      • Username—enter your CData Connect Cloud username. This is displayed in the top-right corner of the CData Connect Cloud interface. For example, test@cdata.com.
      • Password—enter the PAT you generated on the Settings page. Note: The password portion of the connection string should not contain any forward slashes, because Bubble interprets them as separators. Replace any forward slashes with the URL-encoded string %2F.
    • Note: it is also possible to add a database connection name at the end of the connection string like sql://[Username]:[Password]@tds.cdata.com:14333/[ConnectionName].

  7. Click Test the connection. If the connection succeeds, this button becomes gray and says Database connected as shown below.