Now we’ll access Scriptcase from Scriptcase from the browser and create a connection with the PostgreSQL
Step 1: Access your Scriptcase, for example, http://localhost:8081/scriptcase/ on
go to the marked icon in the image below, referring to “New Connection”.
Step 2: After clicking “New Connection”, the page for creating connections will appear, click on the
PostgreSQL database image.
Step 3: On the following image, place the required information:
Connection Name - Define the name of your new connection.
DBMS Driver - Allows you to define the driver that’ll be used, by default it’s PostgresSQL PDO.
Test Connection - Validates the connection and informs if it was successful or not.
Server/Host (Name or IP) - Inform the location of the PostgreSQL database.
Port - Inform the port to be used for your connection. By Default port is 5432.
Database Name - Select the name of your database.
User - Inform the user of your PostgreSQL database.
Password - Inform the password of your PostgreSQL database.
For more details on configuring the connection of the database click on Advanced
Decimal Separator - Select the type of separator, between coma and period.
Persistent Connection - Persistent connections are connections that don’t close after running
Use the schema before the table name - Allows the use of schemas before the table names.
Filter - By clicking on this tab, you will see this page:
Show - Allows to show Tables, Views, System Tables and Procedures.
Searches - Allows to define which tables and owners will be shown.
Step 4: Always test your connection before saving, if the message “Connection Success” appears, then
save the connection. If it fails to connect, revise the fields that were informed, especially Username, Password,
Database and Server/Host.