Creating OLEDB Connection using Qlik API Engine

skusuma1991 — Tue, 04 Mar 2025 10:02:23 GMT

Hi All,

I want to automate some stuff and for that i need to create OLEDB Connection using Qlik Engine API's. I am able to create folder connection but facing issues while creating OLEDB. Error: Invalid parameters and i have double checked the parameters but issue is still exists.

Json used:

{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "CreateConnection",
  "handle": 1,
  "params": [
    {
      "qName": "MySQLConnection",
      "qConnectionString": "Provider=SQLOLEDB;Data Source=your_server;Initial Catalog=your_database;User Id=your_user;Password=your_password;",
      "qType": "OLEDB"
    }
  ]
}

Is there anyone who did this already?

Thanks

Re: Creating OLEDB Connection using Qlik API Engine

JandreKillianRIC — Wed, 05 Mar 2025 07:52:08 GMT

Hi @skusuma1991

I have connected to Qlik Engine API, But this uses web sockets so a normal Rest API connection wont work.

https://help.qlik.com/en-US/sense-developer/November2024/Subsystems/EngineAPI/Content/Sense_EngineAPI/introducing-engine-API.htm

You cant test in using the Dev-Hub

http://localhost:4848/dev-hub/engine-api-explorer for Qlik Sense Desktop
https://[server]/dev-hub/engine-api-explorer for Qlik Sense Enterprise

Regards Jandre

topic Re: Creating OLEDB Connection using Qlik API Engine in Qlik Automate

Creating OLEDB Connection using Qlik API Engine

Re: Creating OLEDB Connection using Qlik API Engine