Skip to main content
NetApp Response to Russia-Ukraine Cyber Threat
In response to the recent rise in cyber threat due to the Russian-Ukraine crisis, NetApp is actively monitoring the global security intelligence and updating our cybersecurity measures. We follow U.S. Federal Government guidance and remain on high alert. Customers are encouraged to monitor the Cybersecurity and Infrastructure Security (CISA) website for new information as it develops and remain on high alert.
NetApp Knowledge Base

Resolution Guide for Data Warehouse Extract Transfer Load (ETL) from OnCommand Insight Server connector

Views:
23
Visibility:
Public
Votes:
0
Category:
oncommand-insight-data-warehouse
Specialty:
oci
Last Updated:

Applies to

  • OnCommand Insight Server (OCI)
  • Data Warehouse (DWH)
  • OCI Connectors
  • Extract, Transfer, Load (ETL) process

Resolution

This KB provides information related to the Data Warehouse ETL process of pulling data from OCI connectors.

DWH ETL connector basics Details
How to add OCI Server connectors to DWH Add OCI Connector to DWH to transfer data

High level DWH ETL overview

  • How DWH extracts data
  • DWH ETL process overview
DWH ETL Scheduling and Frequency
  • How often ETL happens by default
  • ETL schedule and frequency is configurable
How Historical data is retained
  • Default historical data retention settings
  • Data retention settings is configurable
  • Understanding data retention helps when sizing a DWH server
Managing ETL Jobs that pull data from OCI Connectors
  • Check the status of currently running jobs
  • Check the status of historical jobs
How to notify if ETL job has failed Set up email notifications for failed ETL jobs
 
Known issues that have prevented ETL from completing successfully Details
Blocked port 3306 causes OnCommand Insight (OCI) Data Warehouse (DWH) connector ETL to fail Port 3306 is required for OCI server and DWH data transfers
DWH ETL fails with : Failed running inventory job when OCI and DWH versions are mismatched OCI and DWH must be running the same versions of software
Data Warehous ETL "Jobs failed" when OnCommand Insight Server shut down during ETL transfer
  • Both OCI and DWH systems must remain online for ETL to complete
  • Automatic Windows updates often invoke host reboot.
OnCommand Data Warehouse ETL fails and user is unable to access the ‘Connectors’ window due to DWH password encryption file mismatch DWH Password Encryption keys do not match Encryption keys used by OCI Server
OnCommand Insight Data Warehouse Extract, Transform, and Load (ETL) fail due to a full table in the MySQL database

Additional Information

additionalInformation_text

 

Scan to view the article on your device