Hi Crystal Report Support Team.
Is there a way for us to connect to Hazelcast in Crystal Report?
We need to connect to Hazelcast and execute SQL in Hazelcast in Crystal Report so that we can display data on Crystal Report.
We tried
(Scenario 1) Using SAP Crystal Report 2020 on Windows: CR throws error "Failed to open a connection" when connect to Hazelcast in Crystal Report using latest v5.2 Hazecast JDBC Driver, using the same Hazelcast JDBC Driver Connector.
(Scenario 2) Using DBeaver tool: DBeaver successfully opens connection to Hazelcast and we can retrieve data from Hazelcast Maps in DBeaver.
Attached are the screenshots I captured from CR and DBeaver. I have collected CR trace files for investigations.
Currently we are following the below guide link to
* to connect to database using JDBC
https://userapps.support.sap.com/sap/support/knowledge/en/1527666
* to retrieve the Crystal Report Trace Log
https://userapps.support.sap.com/sap/support/knowledge/en/1603398
https://kenhamady.com/cru/archives/2075
https://www.computerhope.com/issues/ch000549.htm#windows10
Appreciate you could shed some lights and guidance.
With best regards,
Eng Kian
Attachment:
JDBC Trace logs
Screenshots
(1) Hazelcast JDBC in the Classpath of CRConfig.xml

Connection
(2) Using SAP Crystal Report 2020

(3) Create JDBC Connection to Hazelcast

(4) Try connect to Hazelcast

(5) CR failed to open JDBC connection to Hazelcast

Scenario 2: Using DBeaver
(1) Specify JDBC Connection to Hazelcast

(2) Can open JDBC Connect to Hazelcast from DBeaver

