cancel
Showing results for 
Search instead for 
Did you mean: 

Connect PostgreSQL after SSH by CrystalReport

NicolasGlatz
Explorer
0 Kudos
89

Hi, we have CrystalReport in 2020 and 2016

2016 i can work with my "old" Database, in 2020 i find no Database. There i have a second question in the community.

 

now we have a second server, this server (docker) i only arrive by SSH.

is there any way in CrystalReport 2016 or 2020 to connect the PostgreSQL Database over SSH

View Entire Topic
DonWilliams
Active Contributor
0 Kudos

SSH is between the Client and Server, Crystal doesn't care how it connects it just assumes the connection is working.

Contact PostgreSQL on how to configure the Client.

Here are the supported Clients, note CR 2020 is BI 4.3 family:

PostgreSQLPostgreSQL (21)9.6ODBC  PostgreSQL 9.6 ODBC  End of Support
JDBC   PostgreSQL 42.1 JDBC End of Support
10ODBC  PostgreSQL 10 ODBC  End of Support
JDBC   PostgreSQL 42.2 JDBC End of Support
11ODBC NewPostgreSQL 11 ODBC  End of Support
JDBC  NewPostgreSQL 42.2 JDBC End of Support
12ODBC BI 4.3 SP01+PostgreSQL 12 ODBC  Direct
JDBC  BI 4.3 SP01+PostgreSQL 42.2 JDBC Direct

 

13

ODBC BI 4.3 SP02+PostgreSQL 13 ODBC  Direct
JDBC  BI 4.3 SP02+PostgreSQL 42.2 JDBC Direct
14ODBC BI 4.3 SP03+PostgreSQL 13 ODBC  Direct
JDBC  BI 4.3 SP03+PostgreSQL 42.3 JDBC Direct
15ODBC BI 4.3 SP04+PostgreSQL 13 ODBC  Direct
JDBC  BI 4.3 SP04+PostgreSQL 42.3 JDBC Direct

(21) Function and Procedure are relevant but different objects in PostgreSQL, only Function is supported in Crystal Reports. Functions are listed under "Stored Procedures", e.g., in CR ODBC driver. For more information, see https://me.sap.com/notes/3403784