How to create your own custom WFA dictionary to retreive ...



-678180-4857750014668502286000Technical Report TITLE \* MERGEFORMAT How to create your own custom WFA dictionary to retreive data from your own custom playground Table USERNAME \* Caps \* MERGEFORMAT Mirko Van Colen, NetAppCreation : CREATEDATE \@ "MMMM '’'yy" \* MERGEFORMAT oktober ’13Last Saved : SAVEDATE \@ "d MMMM yyyy" \* MERGEFORMAT 13 oktober 2013Last Saved By : LASTSAVEDBY \* MERGEFORMAT Mirko Van ColenNumber of pages : NUMPAGES \* MERGEFORMAT 9 00Technical Report TITLE \* MERGEFORMAT How to create your own custom WFA dictionary to retreive data from your own custom playground Table USERNAME \* Caps \* MERGEFORMAT Mirko Van Colen, NetAppCreation : CREATEDATE \@ "MMMM '’'yy" \* MERGEFORMAT oktober ’13Last Saved : SAVEDATE \@ "d MMMM yyyy" \* MERGEFORMAT 13 oktober 2013Last Saved By : LASTSAVEDBY \* MERGEFORMAT Mirko Van ColenNumber of pages : NUMPAGES \* MERGEFORMAT 9 TOC \o "1-2" \h \z \u How to create your own custom WFA dictionary to retreive data from your own custom playground Table PAGEREF _Toc369456035 \h 1Mirko Van Colen, NetApp Creation : oktober ’13 PAGEREF _Toc369456036 \h 1Last Saved : 13 oktober 2013 Last Saved By : Mirko Van Colen Number of pages : 9 PAGEREF _Toc369456037 \h 11Document Control PAGEREF _Toc369456038 \h 31.1Distribution PAGEREF _Toc369456039 \h 31.2Version History PAGEREF _Toc369456040 \h 32Add a customer playground database PAGEREF _Toc369456041 \h 43Insert data in the database from within WFA ? PAGEREF _Toc369456042 \h 44Create WFA object PAGEREF _Toc369456043 \h 45Create a new filter for your object. PAGEREF _Toc369456044 \h 56Create a new finder for your object. PAGEREF _Toc369456045 \h 67Create your own command to go with the object. PAGEREF _Toc369456046 \h 78Create a workflow to use your custom command PAGEREF _Toc369456047 \h 9Document ControlDistributionNameRole USERNAME \* MERGEFORMAT Mirko Van ColenPSC Netapp BelgiumMirko.vancolen@ USERADDRESS \* Caps \* MERGEFORMAT USERADDRESS \* MERGEFORMAT Table SEQ Table \* ARABIC 1 : DistributionVersion HistoryDateChange ReferenceAuthorVersionSections Affected CREATEDATE \@ "M/d/yy" \* MERGEFORMAT 10/13/13Version createdMVC1.0ALLTable SEQ Table \* ARABIC 2 : Version HistoryHi all,I had to create a customer table in the playground database, insert data in de database from WFA and then retrieve those back later in a WFA custom dictionary (what I call “object”)My table was to store CHAP credentials during a vserver-create workflow.Then I needed to retrieve them again during a iscsi-lun create workflow, to have them ready as return values for the workflow initiator. And as the chap-credentials are not included in any current WFA dictionary, I’ve had to create my own.Add a customer playground databaseUsing SqlYog (a mysql gui) it was easy to connect to MySQL and create a customer table.? Insert data in the database from within WFA ?I created my own MySQL insert/update command (made it somewhat dynamic, so it could be re-used for other projects).I documented this command in a separate document : Create WFA objectI've called mine : "chap_credentials".Add a new schema (as your object cannot be in an existing WFA-scheme.? I called my scheme "cm_storage_%name-of-the-project%", as it was a clustered ontap project.Add rows to you dictionary (vserver, cluster_ip, chap_username, chap_password)Create a new filter for your object.? Give it the dictionary type you created earlier.Write your query to retrieve a record from your custom table.? Make sure to return all fields you need (not just the primary keys)Create a new finder for your object.Give it the dictionary type you created earlier.Select the filter you created earlierImportant : make sure you have all fields returned (at least the ones you need)Create your own command to go with the object.I needed a retrieve-only command, so I created my own "no-op-storage command"Create a workflow to use your custom commandUse your custom finder to retrieve the data from SQL.Voila, return your customer properties from your own custom table ! ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download