Using Amazon Redshift for your data warehouse

Birst can be set up to use an Amazon Redshift data warehouse. Amazon Redshift works like any other data warehouse database, except that it is outside of the Birst data center. You can create and manage your own Redshift clusters. Birst connects to the clusters you create on Redshift in order to create spaces.

  1. Create an Amazon Redshift cluster.
    Note: Refer to the Amazon Redshift documentation for information on how to set up a Redshift cluster: http://aws.amazon.com/documentation/redshift/.
  2. After creating an Amazon Redshift cluster, configure a connection from Birst to the Redshift cluster. This allows Birst to access the data warehouse in Redshift.
    1. Log in to Amazon Web Services and select Redshift, then select the cluster you want to connect Birst to.
    2. Note the Cluster Name, Master Username, and JDBC URL on your cluster's configuration page. You need this information to set up your Birst configuration.
  3. In Birst, navigate to Admin > External Databases. A table with defined clusters is displayed.
  4. Click + to create a new defined cluster.
  5. Specify this information on the Create Configuration window with the Redshift cluster information:
    External Database Type
    Select Amazon Redshift
    Name
    Tthe cluster name from the Redshift cluster configuration page.
    Description
    The description for your external database.
    Region
    The region your database is housed.
    JDBC URL
    The JDBC URL from the Redshift cluster configuration page.
    Username
    Username of the user that owns the database from the Redshift cluster configuration page. Sometimes referred to as the "database master."
    Password
    The master user password you used to create the Redshift cluster.
    S3 Bucket
    The S3 bucket path that is used in Birst ETL to store temporary files.
    S3 Access Key
    The access key of the given S3 bucket.
    S3 Secret Key
    The secret key of the given S3 bucket.
  6. Click Save.
    A message is displayed indicating if the external database was created successfully. The external database is then listed in the Defined Clusters table on the External Databases page.
    To edit an existing cluster, you can click the Edit icon for that cluster. The Edit Configuration page is displayed.
    You can click the Actions Icon for a specific cluster to test its configuration, create a time table, or delete the configuration.
    Now, you can Spaces on external clouds from an external Amazon Redshift database.