The XenData COM/SQL interface is provided by a COM API which was introduced into XenData Archive Series software from version 6.20 build 2356. This interface is useful when an application author wants to achieve a higher level of integration with the archive than is possible using standard Windows or network file system APIs. For example, in a situation where a number of data cartridges have been exported from a robotic library and a user wants to restore a file that is located on one of the exported cartridges, it might be useful for an application to be able to tell the user the barcode label of the cartridge that contains the file. The standard Windows file system API provides no method to retrieve that information but this is easily achieved with the XenData COM API.
Use of the COM/SQL interface is preferred over the XenData legacy C++ interface. The legacy C++ interface will be included in releases of XenData Archive Series for the foreseeable future but will not be further developed.
The XenData COM API exposes an OLE DB provider interface that allows the user to access system data via SQL queries. The system supports a read-only subset of standard SQL Language features which can be used to access the available SQL Tables. A number of standard SQL Functions provide a mechanism to perform calculations on result sets.
XenData Archive Series software allows creation of a number of reports using its Report Generator. If an application author wants to obtain custom reports, this can be achieved using SQL queries made via the XenData COM API.
The COM objects documentation is based on IDL syntax. Corresponding language dependent syntax is described in C++ Syntax, C# Syntax and Windows PowerShell Syntax sections of the Guide. A full description of the interface is given in the COM API Programmers Guide, available here as XenDataCOM.chm:
PBS
XenData’s fully supported clustered server meets all the requirements for our disaster recovery site. We have been very pleased with the SX-525 product and XenData’s technical team who have provided system design and integration services above and beyond expectations.
Crew Cuts
I did my research, and the best archive solution was from XenData which manages a robotic LTO library behind the scenes. This helps to minimize our total costs and allows us to focus on producing great content for our customers.
Ideal Systems Singapore
We partnered with XenData for the GlobeCast Broadcast facility rollout, because it offers one of the most cost effective, robust digital video archives on the market and a great migration alternative to some of the more expensive digital video archive vendor offerings.
North Shore Automation
Having completed over 25 joint installations of XenData archive systems, we have found everyone on the XenData team to be both highly professional and super responsive and their technology to be rock solid. They are truly a pleasure to work with.
This is Just a Test
With over 558 TB of content and growing, conventional backup solutions just don’t work for us. Our XenData system allows us to maintain an ongoing mirrored copy of our shared storage while creating replica LTO copies for offsite storage.
Excelencia
We have now installed over 170 XenData archive systems across Mexico and they have proven to be very reliable. In addition, the technical support from XenData has been outstanding.
