Amazon Redshift DBFit Connection File and Setup

For Data Warehouse developer, DBFit is a neat unit – testing tool for database objects and stored procedures. This tool allows you to write the test cases in a tabular, relational form, without requiring you to learn or use an object oriented language.

In this article, we will discuss about the Amazon Redshift DBFit connection and setup. Please comment if you need anything to be added or missing.

Read:

• Netezza Aginity Setup and Configurations
• Netezza ODBC setup
• Resolution: Amazon Redshift Drop and Truncate Table Running Slow
• Redshift Install SSL Certificate in Local Windows System

Install SSL certification file on your local machine

Switch to the bin folder of your local JRE package

Examples: Go to Command prompt and run as an administrator. Enter below command:

cd "C:\Program Files\Java\jre1.8.0_72\bin"

Execute Keytool command to store private key

keytool -keystore "<JRE_Directory>\lib\security\cacerts" -alias redshift2 -import -file "<Location of your pem file>"

Create Amazon Redshift DBFit Connection File

The DB conn file will contain all the necessary information to connect to the Amazon AWS Redshift database. You will need to create it if you don’t have an existing one on the mentioned folder.

Location of the DB connection file

It will be located in the main DBFit folder with the start bat file. If that file is not available, then you have to create same with necessary details.

Name of the DB connection file

The Name of the DB connection file can be anything. The same name should be referred in connection set up page of DBFit. It is always better to follow some naming convention and use same name in your team to avoid confusion.

Content of the DB connection file

Amazon Redshift DBFit Connection String

connection-string=jdbc:redshift://<redshift_host>:<port>/<database_name>?user=<user_name>&password=<password>&ssl=true

Start local dbfit instance

Once you have created the Redshift connection file and same is referred in the set up page, then go ahead and start instance. Please note that, you need to create the Redshift test as a Postgresql test

Go to the DBFit folder and run the startFitnesseDynamiclly.bat and enter the parameter.

The final step is go to browser and access the DBFit

URL : http://<host_name>:<port>/<dbfit_project>

For Examples,

http://localhost:8085/test_demo