Using custom schema with IBM Netezza appliance

You can use Private eazyBI custom schema with data warehouse in IBM Netezza database appliance.

Database connection setup

Download the latest Netezza JDBC driver and copy nzjdbc3.jar file to eazybi_private/lib directory to ensure that it is loaded during Private eazyBI startup.

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

# Settings for accounts with custom schemas
[accounts."Netezza account"]
driver = "jdbc"
jdbc_driver = "org.netezza.Driver"
jdbc_url = "jdbc:netezza://netezza-host-name/netezza-database-name"
username = "netezza-user"
password = "netezza-user-password"
schema_rb = "schemas/netezza_schema.rb"

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