topic Re: How to configure Progress OpenEdge data source with Qlik Cloud and QDG in Data Movement & Streaming

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

madsoncamara — Wed, 19 Mar 2025 21:46:28 GMT

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/ODBC-DrectAccess/sample-connection-strings.htm;
- QDG is working correctly with Microsoft SQL Server.

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

Best Regards,
Madson

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

Ranganath_DR — Thu, 13 Feb 2025 17:53:43 GMT

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/ODBC-DrectAccess/Create-ODBC-connection.htm

https://help.qlik.com/en-US/cloud-services/Subsystems/ODBC_Connector_help/Content/Connectors_ODBC/ODBC-DrectAccess/ODBC.htm#anchor-2

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.

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.

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

madsoncamara — Tue, 18 Feb 2025 17:22:19 GMT

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.

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

madsoncamara — Fri, 21 Feb 2025 18:03:35 GMT

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!