Using custom schema with Amazon Redshift database

You can use Private eazyBI custom schema with data warehouse in Amazon Redshift database. It is recommended to use Redshift database only if you are running Private eazyBI on Amazon EC2 instance in the same Amazon region as it is necessary to have high speed network connection between Private eazyBI application server and Redshift database servers.

Database connection setup

Download Redshift JDBC 4.1 driver and copy this RedshiftJDBC41-*.jar  file to eazybi_private/lib directory.

In eazybi.toml configure which eazyBI account should use Redshift connection (in this example the account with a name "Redshift account"). Replace redshift-* placeholders with corresponding host, database, username and password values.

# Settings for accounts with custom schemas
[accounts."Redshift account"]
driver = "jdbc"
jdbc_driver = "com.amazon.redshift.jdbc41.Driver"
jdbc_url = "jdbc:redshift://your-host-name.redshift.amazonaws.com:5439/redshift-database"
username = "redshift-user"
password = "redshift-user-password"
schema_rb = "schemas/redshift_schema.rb"

After that create custom schema in config/schemas/redshift_schema.rb (or use another file name) and create corresponding eazyBI account.

Using example FoodMart database data

If you would like to test Redshift database then you can import example FoodMart database data:

After that configure connection to Redshift in eazybi.toml file as described above. You can use an example schema definition file schemas/foodmart_schema.rb as a value for schema_rb parameter.