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 Netezza DBFit connection and setup. Please comment if you need anything to be added or missing.
Read:
Create Netezza DBFit Connection File
The DB conn file will contain all the necessary information to connect to the Netezza 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
service=This is the Netezza host name to that you are connecting username=User name that used to connect to Netezza host that you provided in previous step password=Password associated with the above user name database=Database name of the Netezza host to that you are connection or executing test cases against.
Start local dbfit instance
Once you have created the Netezza connection file and same is referred in the set up page, then go ahead and start instance.
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