Help with Postgresql data source

[gbunce]

I have created a Postgresql data source but I am having trouble accessing the table I'm after.

I get the message "JDBC connection string not specified" when I do a test load

My config is pictured below. I loaded the jar file to the mid server also

[Ankur Bawiskar]

Hi Bunce,

It seems something you haven't given as parameter.

The jdbc connection name etc. Were you able to test the connection properly.

Is data coming into import set table?

Mark Correct if this solves your issue and also hit Like and Helpful if you find my response worthy based on the impact.
Thanks
Ankur

[gbunce]

I added the connection string in the Connection URL box as jdbc:postgresql://<hostname>:<port>/<dbname>

and now I am getting the message "The connection attempt failed."

No data is loaded

[Emerce2000]

Were you able to work out the Postgre Connection?

[gbunce]

Yes, I had to add the server as an IP address instead of the server name, and added the JDBC connection as jdbc:postgresql://xxx.xxx.xxx.xx:<port>/<databasename>