You can import data from Google Cloud Storage (GCS) to create source datasets in Anaplan Data Orchestrator (ADO). To import data, you need a connection to GCS and either a pipeline or a connection extract.

You must first create a connection to GCS with the GCS connector in Data Orchestrator. Then use that connection to either create a pipeline or use a connection extract for data import.

Prerequisites

Before you create a connection and import data, you need to meet these connectivity and CSV file prerequisites.

Connectivity prerequisites

Before you can create a connection to GCS, you need to meet these prerequisites.

ItemNotes
Google Cloud Storage (GCS) bucketA GCS bucket that's hosted on Google Cloud Platform (GCP).
GCS user and connection details

A GCS user with these connection details:

  • GCP service account email.
  • GCP private key.
  • Bucket name with at least read permissions for the bucket and objects.
GCS folder path for bucketYou need the folder path to a subset of the bucket.

CSV file prerequisites

CSV files uploaded to Data Orchestrator must be UTF-8 encoded. See File requirements for Anaplan Data Orchestrator for more information about CSV file requirements.

Create a connection to Google Cloud Storage

To create a connection:

  1. Select Data Orchestrator from the top-left navigation menu.
  2. Choose a dataspace from the list.
  3. Select Connections from the left-side panel.
  4. Select Create connection.
  5. Select the Google Cloud Storage connector and then select Next.
    If you can't find the connector, enter a search term in the Find... field.
  6. Enter these details on the Connection details screen, and then select Next:
    • Name: Create a name for your connection. The name can contain alphanumeric characters and underscores.
    • Description: Optionally, enter a description about your connection.
  7. Enter your Google credentials on the Connection credentials screen, and then select Next:
    • GCP Service Account Email: Enter your GCP service account email (for example, XXXXXXXXXXX-compute@developer.gserviceaccount.com). 
    • GCP Private Key: Enter GCP private key
      For example:

-----BEGIN PRIVATE KEY-----

************************************************************

... (Your private key content in Base64) ...

... multiple lines ...

-----END PRIVATE KEY-----

    • Bucket name: The GCS bucket where your data is stored (for example, GCS-EXAMPLE-BUCKET).
  1. After the connection test is complete, select Done.

Import data

You can import data from Google Cloud Storage with a pipeline or a connection extract. Use the connection you created to configure the pipeline or connection extract.