Subscribe
Accepted Solution

WFA - user input query for custom vsc datasource

 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

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

[ Edited ]

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

 

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

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

[ Edited ]

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