idea Data Connections in QMC in Suggest an Idea

Data Connections in QMC

AndrewMcIlwrick — Fri, 20 Dec 2019 06:34:45 GMT

It should be possible to create Data Connections in QMC. There is an API after all. Doing it in hub apps is not sustainable in a proper enterprise scale org.

Re: Data Connections in QMC

vegard_bakke — Wed, 20 Feb 2019 13:59:38 GMT

I second this suggestion. Especially for QAP installations, where you cannot easily create data connections in an app, as you cannot open the app.... 😕

Re: Data Connections in QMC

Mauritz_SA — Thu, 28 Feb 2019 09:24:15 GMT

Really need this as it requires the admin user to have/consume a professional license to create a data connection even though they never use apps.

Re: Data Connections in QMC

Tito — Fri, 15 Mar 2019 16:35:29 GMT

Is this feature added on the roadmap?

Re: Data Connections in QMC

John_Teichman — Tue, 05 Nov 2019 12:13:56 GMT

Closing - this is a duplicate of https://community.qlik.com/t5/Qlik-Sense-Enterprise-Ideas/Create-Data-Connection-on-QMC/idi-p/1499657

Re: Data Connections in QMC - Status changed to: Closed - Duplicate

John_Teichman — Tue, 05 Nov 2019 12:14:06 GMT

Re: Data Connections in QMC

Mauritz_SA — Tue, 05 Nov 2019 12:21:24 GMT

Hi @John_Teichman

Thanks for the update. Is there any update on the progress though? Has it been evaluated? Since the qrs API already exists for it it seems like something that should be simple to add.

Regards,

Mauritz

Re: Data Connections in QMC

John_Teichman — Tue, 05 Nov 2019 13:33:19 GMT

We are in the midst of a review of the existing ideas before we roll out improvements to the program. As part of the review, we are looking at all of the ideas. We have seen requests like this before, however, I do not believe this is currently under consideration by the product manager.

Re: Data Connections in QMC

vegard_bakke — Tue, 05 Nov 2019 18:36:50 GMT

Sorry, to keep iterating on a closed issue, but why did you close the request with the more likes, and the most debate? Would it not be better to close: https://community.qlik.com/t5/Qlik-Sense-Enterprise-Ideas/Data-Connections-in-QMC/idc-p/1643171?

Re: Data Connections in QMC

AndrewMcIlwrick — Fri, 08 Nov 2019 07:57:48 GMT

I agree. Totally disappointed. Putting duplicates to one side which is fair enough, I feel there is sometimes a disconnect between product feature prioritization between customers and R&D. This was evidenced from feedback discussion at luminary event in Lund. In large enterprise environments these sorts of feature gaps may seem insignificant to Qlik but will in fact form negative views about the product's capability from teams who hit issues with deployments and also automation.

Re: Data Connections in QMC

AndrewMcIlwrick — Fri, 22 Nov 2019 18:45:05 GMT

Thanks for the continuous likes - unfortunately it looks as if this one is not going to be prioritized any time soon.

Re: Data Connections in QMC

AndrewMcIlwrick — Mon, 02 Dec 2019 19:51:38 GMT

Another like today ! So if Qlik cannot add this to their product backlog can we work together to come up with a workaround solution ? We can utilize the API's to do the DC creation via a script, publish it on GitHub and then at least we have a comman line driven alternative.

https://help.qlik.com/en-US/sense-developer/November2019/Subsystems/RepositoryServiceAPI/Content/Sense_RepositoryServiceAPI/RepositoryServiceAPI-Data-Connection-Create.htm

Thoughts ?

Or how about a new QMC app Mark II ?

Re: Data Connections in QMC

rbartley — Fri, 01 May 2020 14:46:53 GMT

A thousand times yes to this. The current way of creating data connections is incredibly frustrating.

Re: Data Connections in QMC - Status changed to: Partially Delivered

Thomas_Hopp — Wed, 20 May 2020 13:28:50 GMT

Hi @AndrewMcIlwrick coming back to your idea and the status of it. We did recently delivered to our SaaS offering as part of the April Release the ability to create / manage & maintain data connections and data files as part of a Space. That capability makes it a way easier to manage your data connections outside of an App and still using those across multiple Apps as part of multiple Spaces. We are currently not planning to include that capability into the on premise Windows product but we will improve this even more in the SaaS world to make it a very seamless integration into the developer workflow.

More than happy to talk more in detail about this if you want.

Best regards,

Thomas

Re: Data Connections in QMC

AndrewMcIlwrick — Wed, 20 May 2020 14:57:23 GMT

Thanks - acknowledging the progress but imo it is not a complete solution. Many customers will continue to want on-premise Windows Sense for the foreseeable future. I used to work for a US bank - with an enterprise account - and they are a prime example of a customer who are unlikely to ever use Qlik SaaS. Therefore, the lack of QMC data connection creation is still a major feature gap. Given the API's are there this should be a relatively simple UI change to add a create button and parameterise a form ?

Re: Data Connections in QMC

vegard_bakke — Mon, 31 Aug 2020 11:33:02 GMT

The best workaround I've found is in PowerShell

Install-Module Qlik-CLI Import-Module Qlik-CLI Connect-Qlik New-QlikDataConnection -name <name> -type <type>

Then you can edit the connection string and other attributes from QMC.

For more info, visit:

https://ahaydon.github.io/Qlik-Cli-Windows/New-QlikDataConnection.html

Re: Data Connections in QMC

AndrewMcIlwrick — Mon, 31 Aug 2020 13:50:48 GMT

This is a useful tip but to me the core QMC site should really have this. Not everyone is allowed to use Powershell or Qlik-Cli.

Re: Data Connections in QMC

vegard_bakke — Mon, 31 Aug 2020 14:20:19 GMT

I totally agree. Especially when it's sooo easy to add button that does an existing API call. They even have the form with all the data connection fields ready in the Edit mode.

Now that Qlik Desktop is gone, I wonder what the official policy is to create a data connection on a QAP server.

Re: Data Connections in QMC

barnabyd — Mon, 01 Jul 2024 01:57:28 GMT

Is this feature on the roadmap yet?

For the larger clients that I have worked with, it is usually the Qlik server admin that creates the data connectors ready for us developers to use when we build our apps. It doesn't make sense for them to create a temporary app so that they can create the Data Connector and then delete the app.

The other annoying current 'feature' is that QS automatically appends the user name to the end of the connector - I would assume that if the connector was created in QMC, then it would take the name given and not append the username.

It is currently a very cumbersome process to create a new connector.

Thanks, barnabyd.