How to configure Progress OpenEdge data source with Qlik Cloud and QDG

[madsoncamara]

Hello,

Has anyone managed to use the Progress OpenEdge data source with Qlik Data Gateway?

I am getting error "Status(StatusCode="Internal", Detail="Command testconnection returned non-success: Error message: Please check the values ​​for Username‚ Password‚ Host and other properties. Description: Invalid connection string attribute - ERROR [08001] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused. Verify Host Name and Port Number. ERROR [HY000] [DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Connection refused.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server. Verify Host Name and Port Number.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: Server.[DataDirect][ODBC Progress OpenEdge Wire Protocol driver]Invalid attribute in connection string: gatewayInstance."

What was done:
- Installed the Progress 12.2 ODBC Driver driver, configured it and the connection test was successful;
- During the connection, an attempt was made to fill in the Connection String field as shown in the example image available at https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...;
- QDG is working correctly with Microsoft SQL Server.

Could you help us with how to fill in these attributes?

Best Regards,
Madson

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[Ranganath_DR]

Hi @madsoncamara ,

If connection is successful in ODBC driver, I would recommend to try the system DSN option and see if it works and note that Third-party ODBC drivers are supported on a best-effort basis.

https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...

https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/OD...

Database properties	Description	Required
System DSN	Choose one of the following: System DSN: This option requires you to define a System DSN for your data source. For more information, see Creating a System DSN.

Opens in new window

PDF Download

Word Download

Excel Download

PowerPoint Download

Document Download

[madsoncamara]

Hi @Ranganath_DR,

The customer is still facing the problem, even with DSN configuration.

We have forwarded an ODBC driver from a similar environment that is working correctly with DB Progress and I am awaiting feedback from the customer.

Thank you for your support.

[madsoncamara · Accepted solution]

Hi @Ranganath_DR

We were able to resolve this issue together with the customer.

The connection string for Progress OpenEdge is:
HostName=IP;PortNumber=xxxx; DatabaseName=DBName;UserId=user;Password=pass;

Thanks for your support!