Creating Qlik Cloud Connectors (KeySurvey)

[Crichter141]

I'd like to use a connector for a product we have called KeySurvey.  I'm never set up a connector and feel like I am jumping into the deep end.  Is there a step-by-step for this?  A white paper?  or has someone else done this?

I am assuming there's a cost for each pull.  Our users want the data pulled every hour sometimes and I want to know how much that is, because the frequency tends to make our costs jump.  Does anyone have any costing tools or suggestions for that before going full-steam ahead on this project?

I hate to say it, but for us it might be cheaper just to automate moving the csv files to where Qlik will pick them up rather than a direct connector.

[marksouzacosta]

Hi @Crichter141,

I see the KeySurvey has some APIs: https://www.keysurvey.com/survey-software/api-integration/. Have to tried those?

Also I don't see any problem if you Automate an Export process. You could, for example, export the CSV files to a folder monitored by Qlik DataTransfer. Qlik DataTransfer will upload these CSV files straight to Qlik Cloud, keeping in sync the data you have in Cloud with your on-prem folder. Qlik DataTransfer is a free tool. For more details: https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/QlikDataTransfer/install...

Regards,

Mark Costa

[Mario_De_Felipe]

There are some ways to connect to a data source:

• If you have direct access to the database you can use an OBDC or the specific-database connector (such as SQL Server, Oracle, MySQL,...). Review connectors here: https://www.qlik.com/us/products/data-sources 
• If you have access via API, you could use the REST Connector and build API calls in your load script.https://help.qlik.com/en-US/connectors/Subsystems/REST_connector_help/Content/Connectors_REST/REST-c... 
• You could develop your own custom connector through QVX: https://help.qlik.com/en-US/sense-developer/May2024/Subsystems/QVXSDKAPI/Content/Sense_QVXSDKAPI/Int....

Hope it helps!