Active IQ Unified Manager Discussions

WFA - user input query for custom vsc datasource

BenCoughtry
3,368 Views

 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

1 ACCEPTED SOLUTION

gpablo
3,362 Views
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

View solution in original post

4 REPLIES 4

gpablo
3,363 Views
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

BenCoughtry
3,355 Views

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

gpablo
3,343 Views

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.

BenCoughtry
3,299 Views

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

Public