I want the operator of workflows choose from a list of snapshot of volumes (e. g. to use it as a base for a cloning operation). For this I need the snapshots of cDOT volumes in a table (e. g. cm_storage.snapshot) in order to use sql statements to select them.
But the solution in thread2 cannot be imported in WFA3.1 (see my comments in both threads). Meanwhile the creator of the solution in thread2 has left NetApp and may not update it. NetApp itself seems not to be able or willing to solve this issue (either in filling this table in WFA by default or porting the solution of thread2 to WFA3.1).
I would create this table, datasource and OCUM/cluster connection by myself, if someone can tell me the steps how to do this.
Is there somebody who can describe/share what to do to get such a table filled with snapshot names from clustered DataONTAP volumes?
A data source type is used to define a data source, which contains information about where the data in a specific database originates and the method used to acquire data from the data source. For example, a data source can be either a OnCommand Unified Manager (OCUM) database that contains information about a storage environment or a VMware database with information about a data center or a OCCM for cloud.
The Data Source Types table lists the available data source types.
“Data Source” displays the name of the data source type.
“Schema” displays the scheme associated with data source type. A scheme is a table that contains data relevant to your environment. For example, avc scheme contains data relevant to your virtual environment, such as virtual machines, hosts, and data stores.
Data Source Types window
The Data Source Types window displays the available data source types and enables you to manage the data source types.
WHEN we need a user defined Data Source?
Let us take an example, OCUM. This unified manager sits between our filers/arrays/vsims and WFA. This is a data manager, manages data coming from attached clusters with it and serves those data to our WFA in a much managed way using (WFA) dictionaries.
HOW it manages all? It has its own dictionaries and APIs to manage the data coming from clusters. But it doesn’t have all the dictionary entry which we can think of in our day to day life. Take an example, Snapshot dictionary. OCUM doesn’t have. So how user will get data related to snapshot from UM? In that time, user needs to define his/her own Data Source Type. For the same, (s)he needs to write a script (WFA 3.1 supports Perl) to fetch information from the attached clusters (as Credentials) with WFA.
Hope this information helps.
To write your own script, you can have a look to other work flows which is using a separate data source.