Creating OLEDB Connection using Qlik API Engine

[skusuma1991]

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

[JandreKillianRIC]

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_EngineAP...

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