topic Re: WFA - user input query for custom vsc datasource in Active IQ Unified Manager Discussions

WFA - user input query for custom vsc datasource

BenCoughtry — Wed, 04 Jun 2025 16:11:35 GMT

Hello,

I have a custom csv datasource of network devices and am building a workflow for users to run commands on a device selected by used input. The workflow should query the csv datasource and allow the user to select the appropriate device through a dropdown menu. I've done similar operations on CDOT clusters using SQL queries within the user input however cannot get this to work on my custom datasource. All queries I try fail with "Failed to execute query for user input: No database selected".

Is what I'm trying to do even possible or would I have to use some other method to have a user select objects within a custom csv datasource?

Thanks,

-Ben

Re: WFA - user input query for custom vsc datasource

gpablo — Tue, 03 Jan 2017 21:28:06 GMT

Hello Ben,

The user input query works with the WFA databse, so You have to import your CSV file into the WFA database before. Check this post http://community.netapp.com/t5/OnCommand-Storage-Management-Software-Discussions/EDM-Pack-Excel-Data-Management-for-WFA/td-p/113416

Hoe this help,
Pablo

Re: WFA - user input query for custom vsc datasource

BenCoughtry — Tue, 03 Jan 2017 23:16:47 GMT

Thanks Pablo. I believe I've already done this while using the following as a guide. Both on-demand and scheduled datasource aquisitions for this CSV are successfull and I can confirm I see the file in WFA's temp directory after aquisition.

https://community.netapp.com/t5/OnCommand-Storage-Management-Software-Articles-and-Resources/Video-Building-your-first-script-based-custom-datasource-using-a-file/ta-p/87679#comment-17935

Unless there is something additional I need to do in order to get the data into WFA DB?

Thank again,

-Ben

Re: WFA - user input query for custom vsc datasource

gpablo — Tue, 03 Jan 2017 21:54:28 GMT

Sorry, I've never used this perl script but the powershell that I sent before. I usually connect to the WFA database with a MySQL client in order to verify that the data are correctly imported.

Re: WFA - user input query for custom vsc datasource

BenCoughtry — Tue, 03 Jan 2017 23:25:56 GMT

Apologies, the link in my first reply was wrong. I've updated the link with the video I used to create the custom datasource from csv.

I confirmed via MySQL Workbench that data within the csv is indeed being imported into WFA's MySQL database. Perhaps I just need guidance on creating SQL queries for the workflow's user input. I'll try using MySQL Workbench query editor for this purpose.

Thanks for your input!

-Ben