Create a Apache Cassandra connection

You're viewing Apigee X documentation.
View Apigee Edge documentation.

The Apache Cassandra connection lets you insert, read, update, and delete rows from the Apache Cassandra database and then use the resulting output in your integration. This page provides a reference for creating a Apache Cassandra connection and using it with Apigee Integration.

Before you begin

Before creating a Apache Cassandra connection, perform the following tasks:

  • In your Google Cloud project:
    • Grant the following roles to the service account that you want to use to create the connection:
      • roles/secretmanager.viewer
      • roles/secretmanager.secretAccessor
    • Enable the following services:
      • apigee.googleapis.com (Apigee API)
      • secretmanager.googleapis.com (Secret Manager API)
      • connectors.googleapis.com (Connector Platform API)

    If these services or permissions have not been enabled for your project previously, you are prompted to enable them when creating the connection in the Create Connection page.

  • Setup the keyspace and tables in your Apache Cassandra database.

Create a connection

  1. In the Cloud console, go to the Apigee > Connectors page and then select or create a Google Cloud project.

    Go to the Connections page

  2. Click + CREATE NEW to open the Create Connection page.
  3. Configure the connection:
    1. In the Create Connection section, complete the following:
      • Connector: Select Apache Cassandra from the drop down list of available Connectors.
      • Connector version: Select the Connector version from the drop down list of available versions.
      • In the Connection Name field, enter a name for the Connection instance.

        Connection names must meet the following criteria:

        • Connection names can use letters, numbers, or hyphens.
        • Letters must be lower-case.
        • Connection names must begin with a letter and end with a letter or number.
        • Connection names cannot exceed 63 characters.
      • Optionally, enter a Description for the connection instance.
      • Service Account: Select a service account that has the required roles.
      • Remote Host: Enter the hostname or the IP address of the Cassandra server(s). You can enter multiple servers as comma separated values.
      • Remote Port: Enter the port number on which the Cassandra server is running. If you don't enter any value, the port number defaults to 9042.
      • Keyspace: Enter the keyspace in the Cassandra server.
      • Optionally, click + ADD LABEL to add a label to the Connection in the form of a key/value pair.
      • Click NEXT.
    2. Location: Choose the location for the connection.
      • Select a location where Apigee is available from the Region drop-down list.

        Supported regions for connectors include:

        • asia-east1
        • asia-northeast1
        • asia-south1
        • asia-southeast1
        • australia-southeast1
        • europe-west1
        • europe-west2
        • europe-west3
        • europe-west4
        • europe-west6
        • northamerica-northeast1
        • southamerica-east1
        • us-central1
        • us-east1
        • us-east4
        • us-west1
        • us-west2
      • Click NEXT.
    3. Authentication:

      Enter the following information:

      • Username: Enter the Apache Cassandra username.
      • Password: Enter the Secret Manager secret containing the password associated with the Apache Cassandra username.
        • If you have previously created a secret, and it is not available in the drop down list, select DON'T SEE YOUR SECRET? ENTER SECRET RESOURCE ID. In the Add a secret by resource ID dialog, copy and paste the resource ID from the Secret Manager.
          • To use the latest version, copy and paste the resource ID from the parent secret, in the format: "projects/project-number/secrets/secret-name"
          • To select a specific version, copy and paste the resource ID for that specific version, in the format "projects/project-number/secrets/secret-name/versions/1"

          Click ADD SECRET to add the secret and close the dialog.

        • If you have not created a secret for use with Apache Cassandra, click ADD A NEW SECRET. In the Create Secret dialog enter the following details:
          • Name: Enter the secret name.
          • Secret value: Enter the contents of the secret.
          • Optionally, click + ADD LABEL to add a label in the form of a key/value pair.
      • Secret version: Select the version of the Password secret from the list of available versions in the drop-down.
    4. Review: Review your connection and authentication details.
  4. Click Create.

Create a Connectors task

After you create a Apache Cassandra connection, it becomes available in Apigee integrations. You can then use the connection to configure the Connectors tasks in your integrations. For more information, see Configure the Connectors task.