How to create data source in SpagoBI

How to create data source in spagobi

Step 1: Run SpagoBI server and Login as biadmin

Step 2: Go to Resources  →  Data source 

Step 3: Click the button Add to create new data source and fill in the information

Label:              Any understandable name

Description:   A little bit description to your data source

Dialect:           Choose the type of your data source (If you create PostgreSQL data source, choose PostgreSQL)

Read only:      choose Read and write

Type:               Jdbc (create the data source using Jdbc driver)

Url:                  jdbc:postgresql://localhost:5432/database_name (if you connect to hosted database, just change from localhost to your server IP). In my case, jdbc:postgresql://192.168.97.40:5432/test

User:               Database Username

Password:       Database password

Driver:             org.postgresql.Driver

Step 4: After filling all the required information, you can test your data source by clicking T button to check if there is any error or not.

If your information is all correct, it says “Data source correctly tested”.

Step 5: Lastly, you can save your data source by clicking save button next to the button test T

Yeah, you finally created the data source in SpagoBI. Well done…