Active IQ Unified Manager Discussions

WFA Data Source for OCI




While this package is still available via direct message through Community, NetApp engineering has taken this work and built a supported version on the Automation Store called OnCommand Insight Connector:


Please download and use the OnCommand Insight Connector as the baseline package for connecting OCI and WFA.





Deprecated information below this line:



This is the first external release of the WFA Data Source for OCI. With this Data Source, WFA users can ingest OCI information into their WFA database for heterogeneous IT automation activity. Prerequisites for this Data Source:

  • WFA 3.0 (or later)
  • PowerShell 3.0 on the WFA Server
  • OCI 7.0 (or later)


The following Dictionary tables are available in this Data Source:

  • annotation
  • datastore
  • datastoreannotation
  • datastoreperformance
  • disk
  • host
  • hostannotation
  • hostapplication
  • hostperformance
  • internalvolume
  • port
  • storage
  • storageannotation
  • storageapplication
  • storagenode
  • storagenodeperformance
  • storageperformance
  • storagepool
  • storagepoolperformance
  • switch
  • switchannotation
  • switchperformance
  • virtualmachine
  • vmdk
  • volume


An example of a Query for a Filter using the WFA Data Source for OCI of all clustered Data ONTAP aggregates not named aggr0:


select SUBSTRING_INDEX(, ':', -1), s.storageId, s.model, s.vendor, s.ip,, s.self, sp.storagePoolId,, sn.storageNodeIdfrom oci.storagePool as sp,oci.storageNode as sn, as swhere s.vendor = 'NetApp'and = 'FAS'and sp.storageId = s.storageIdand sp.type = 'AGGREGATE'and SUBSTRING_INDEX(, ':', -1) not like '%aggr0%'and s.microcodeversion like '%clustered Data ONTAP%'

To create a new Data Source, follow these steps:

  1. Create a backup of your WFA environment.
  2. Import the OCI Data Source into your WFA server.
  3. Use Execution->Data Sources and click New, entering IP, port, user and password credentials for the OCI server and set the timeout value to 3600.
  4. After determining the amount of time to complete data acquisition from the Data Source, reduce the Timeout based on the speed of the OCI data acquisition.


Below is an example of a new OCI Data Source being created in WFA:

2015-04-19 07.51.42 am.jpg


Please post any issues, questions, comments to this thread.