Can a PostgreSQL AWS instance be used

Unknown

Can a PostgreSQL AWS instance be used

Unknown

[color=rgb(0, 0, 0)][font=Roboto, sans-serif]Salutations fellow earth brethren!
[/font][/color]
[color=rgb(0, 0, 0)][font=Roboto, sans-serif]
[/font][/color]
[color=rgb(0, 0, 0)][font=Roboto, sans-serif]Just curious if you support the ability to use an AWS hosted PostgreSQL engine versus AWS MS SQL?[/font][/color]
[color=rgb(0, 0, 0)][font=Roboto, sans-serif]
[/font][/color]
[color=rgb(0, 0, 0)][font=Roboto, sans-serif]Blessed cheese and milky way to you!
[/font][/color]

Unknown

Humble Peanut,

[font=Roboto, sans-serif]Our workflow and rule engine is able to integrate with POSTGRES and all other types of RDS, but Decisions does require either MSSQL, or AZURE SQL, to run as an application. That being said, you can construct all of your business processes/logic to read data from and write it back to your POSTGRES database(s).[/font]
[font=Roboto, sans-serif]
[/font]
[font=Roboto, sans-serif]Bumblebee tuna[/font]

Unknown

Hello,

Ive been working on getting a Database Connection set up as Postgresql. Ive been trying both with/without the Custom Connection String. I have my connections string formatted thusly:

User ID=USERID;Password=PASSWORD;Host=Yaddayadda.us-east-1.rds.amazonaws.com;Port=5432;SSL=true;

Im receiving an error running the TEST saying "Test Failed: Failed to establish a connection to (my server name)"

Version 6.12.1 rev 64872

Any advice on getting this connection set up?

Unknown

Hi Twoh,

The connection string expected may be a different format for Postgresql. I believe it is something similar to:
Server=192.168.1.163;Port=5432;Database=postgres;User Id=postgres;Password=root;

Another consideration to make is making sure traffic is allowed across port 5432 on the server where Decisions is hosted and on your database server.

I hope this helps!

-Andrew

Unknown

Thanks for the reply Andrew, that was very helpful. Ive verified that port 5432 is open, and tried with this type of connection string. Im still hitting

[font="courier new"]Message]:Start Test Connection Npgsql.NpgsqlException: [Exception]:Npgsql.[/font][font="courier new"]NpgsqlException: Failed to establish a connection to [/font]sales-center-read-replica.cqtslxopt5pe.us-east-1.rds.amazonaws.com[font="courier new"]. at Npgsql.NpgsqlClosedState.Open([/font][font="courier new"]NpgsqlConnector context) at Npgsql.NpgsqlConnector.Open() at Npgsql.NpgsqlConnectorPool.[/font][font="courier new"]GetPooledConnector([/font][font="courier new"]NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.[/font][font="courier new"]RequestPooledConnectorInternal[/font][font="courier new"](NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.[/font][font="courier new"]RequestPooledConnector([/font][font="courier new"]NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.[/font][font="courier new"]RequestConnector([/font][font="courier new"]NpgsqlConnection Connection) at Npgsql.NpgsqlConnection.Open() at DecisionsFramework.Data.[/font][font="courier new"]ORMapper.DatabaseDrivers.[/font][font="courier new"]DatabaseDriversHelper.[/font][font="courier new"]TestConnection([/font][font="courier new"]DataBaseTypeEnum type, String connectionString, String databaseFolderId) at DecisionsFramework.[/font][font="courier new"]ServiceLayer.Services.[/font][font="courier new"]DatabaseIntegration.[/font][font="courier new"]DefinitionServices.[/font][font="courier new"]DatabaseDataService.[/font][font="courier new"]StartTestConnection([/font][font="courier new"]AbstractUserContext userContext, DataBaseTypeEnum type, String connectionString, String agentId, Boolean useCurrentDatabase)[/font]

Im now looking into what version of NPGSQL the connector is using. Can you look and find out what version is shipped with Decisions?

Thanks

Unknown

Hi Twoh,

This looks like a permissions error. It might be worth testing the connection between your application server and PGSQL machine. This can be done by downloading a management tool onto your application server such as pgAdmin or using a UDL file to make sure that machine can connect.

To answer your question, Decisions uses v5.0.7 NPGSQL Connector but I do not think version difference is the cause here.