|
|
View Technical Details
|
Easily export data from your MultiValue database for use with:
Microsoft SQL Server® Oracle® mySQL™ DB2®
Rapid, high performance data replication
|
|
Direct mv2SQL
Rapid, high speed data warehouse, data mart, data migration or data integration.
mv2SQL optionally creates the SQL tables that match the single values, multivalues and subvalues that make up your MultiValue data, and then exports this data.
It is truly the fastest way to get your data to the target database system.
No Intermediate formats Required.
mv2SQL is not a store and forward approach, it does not require you to make a "normalized" copy of your data first. |
|
Full Support for Multivalues and Subvalues
Data Access Direct mv2SQLwas designed for use with complex, multi-value and sub-value data by automatically normalizing the data as it passes to a SQL application. This is achieved by not only constructing the primary table, but also the associated multi-value and sub-value tables. This eliminates the need to use the traditional method of flattening the file data before exporting, thus preserving the original data structure. Data Access Direct mv2SQL automatically creates all the correct data definitions in the SQL tables.
Mapping Optional
You can access your MultiValue dictionaries using the DictCall ItemProc routine, which is similar to simple LIST/SORT syntax, access the output of basic programs or TCL commands, or write subroutines to return data.
|
| Platform Information:
MultiValue Platform:
• Most MultiValue databases including: uniVerse,™ UniData,™ mvBase,™ Reality X,™ jBase,™ mvEnterprise,™ D3,™ Advanced Pick,™ and more.
Target Database Support:
• Microsoft SQL Server®
• Oracle®
• DB2®
• mySQL™
|
|
Components Include::
- Data Access Server – required for each MultiValue host computer. Direct Data Access Server— high-performance, low footprint server that provides access to data and logic on your MultiValue database. Supports OLEDB, JDA (Java) and ADO.NET.
- Direct mv2SQL Designer – Used to define the data that will be pulled from the MultiValue data source
- Direct Designer – using our unique automap feature, quickly and easily map MultiValue data as MultiValue data, providing the metadata that Windows applications require in order to accurately and efficiently work with your data and logic.
|
| |
|
Specifications:
- Simple menu interface for ad hoc use.
- Utilizes standards based OLE DB technology that provides much faster data extractions than traditional ODBC driver methods.
- Works in conjunction with Direct Designer OLE DB to map your MultiValue data.
- Export MultiValue data directly to SQL Server, Oracle, DB2, or mySQL.
- Incorporates the ability to use SQL Server Agent to trigger an export of MultiValue data into SQL database with saved templates. Microsoft Task Scheduler can also be used.
- Any host procedure, TCL statement or file that is requested can have the output sent to SQL.
- Relational database table structure created automatically; based on the metadata definitions.
- Complete MultiValue data structure handled, including multi-values and subvalues.
- Save and re-use export definitions as templates, re-population of SQL data tables simply by re-running the template.
- Published API for totally automated use via program control. Application developers can easily integrate as part of their total solution.
- Full error logging provides information about transfer times and other events.
|
|
|