Differences

This shows you the differences between two versions of the page.

--- sync:data_extraction [2021/06/02 03:01] – created Scott Cunliffe
+++ sync:data_extraction [2025/01/21 22:07] (current) – external edit 127.0.0.1
@@ Line 1: / Line 1: @@
 ====== Data Extraction From Source ======
+Data is extracted from your backup software and saved into a Sync source file.  The Sync source file is then read into the synchronization process using a definition file to translate the information to TapeTrack formatting.
+===== Extracting Information =====
+The source file information extract will vary depending on your backup software.
+==== Data Extraction From BackupExec ====
-<- sync:fields| Sync Fields ^ sync:introduction|introduction ^  ->
+The CSV report in BackupExec is created by running a PowerShell script and output to CSV file.
+Further details on the conversion process can be viewed at [[cookbook:backupexec|Backup Exec Cookbook]]
+==== Data Extraction From Commvault ====
+The Storage Information Report is created via the Commvault GUI and output to CSV format, accessible from the reports tab.
+Further details on the conversion process can be viewed at [[cookbook:commvault|Commvault cookbook]]
+==== Data Extraction From Data Protector ====
+The onmirpt command is available on systems with the Data Protector User Interface component installed
+Use the omnirpt command to extract data to a text file using:
+Output from omnirpt, while tab delimitered, can produce offset columns depending on string lengths. To ensure the column offsets are consistent the output is passed through TMSS10CSV2Fixed producing a fixed length text file.
+Further details on the conversion process can be viewed at [[cookbook:dataprotector|Data Protector Cookbook]]
+==== Data Extraction From Netbackup Vault ====
+Using the administrative tool vmquery, the Volume data can be extracted into a text file.
+The text file is then converted to a CSV file to properly format the data, along with the dates, to allow correct loading into the Sync, using the command line program TMSS10SingleSpace.
+Full definition and implementation example for extraction of data and synchronization with Netbackup is at [[cookbook:netbackup|NetBackup Sync Cookbook]]
+==== Data Extraction From Networker ====
+Using the administrative tool mminfo, the Volume data needs to be extracted from the Networker save sets and exported into CSV file format.
+Full definition and implementation example for extraction of data and synchronization with Networker is at [[cookbook:networker|NetWorker Sync Cookbook]]
+==== Data Extraction From TSM ====
+Using the Tivoli Storage Manager administrative tool dsmadmc, the Volume data needs to be extracted from both the DRM and Volume tables and exported into csv file format.
+Full definition and implementation example for extraction of data and synchronization with TSM is at [[cookbook:tsm|Tivoli Storage Manager Sync Cookbook]].
+==== Data Extraction For VEEAM ====
+VEEAM differs from other backup software in that a direct ODBC connection is made using the definition file rather than extracting the data to file and then using a definition file to read it.
+Full definition and implementation example for extraction of data and synchronization with VEEAM is at [[cookbook:veeam|VEEAM Sync Cookbook]].
+<- sync:sources|Sync Sources ^ sync:introduction|introduction ^ sync:fields| Sync Fields ->