====== 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 ====


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 ->