DatabaseBridge

A Powerful Universal HIGH-SPEED Database Management Tool For Data Validation, Transfer and Distributed Query 

Product Introduction

 

Database Bridge is a data management tool that provides various kinds of data integration

and data exchange services in a multiple database environment. These services include read/write distributed query, data validation, copying tables between databases, various kinds of data comparison and data transfer, scheduled job execution, etc. Database Bridge provides a quick and easy way to perform cross DBMS boundary data retrieval, comparison and transfer at a speed superior to that of similar products.

 

Data can be retrieved from multiple relational or non-relational data sources, and table joins can be made among them to reflect their logical relations. Database Bridge can do distributed write queries, such as delete, update and insert to modify data in one database in accordance with data in other data sources. Database Bridge’s distributed query can be used on both relational databases or flat databases ( text file, spreadsheet file, html file, etc). For example, you can insert data from a Microsoft Excel spreadsheet to a table in a DB2 database, or update an Oracle table in accordance with the related data in a Microsoft Access table. Database Bridge does distributed queries so easily and smoothly it feels like you were dealing with data from one database while you are actually working in a multiple database environment.

 

Database Bridge provides various ways to present your data. The data, retrieved through regular or distributed query, can be saved in many formats, such as a XML file, a HTML file, a spreadsheet file, a text file (either delimited or fixed record width), or a new table in a chosen database. In addition, Database Bridge can send data to Crystal Report.

 

Database Bridge lets you copy tables easily from one database to another. You can choose various copy targets: a single table, several tables or even all tables in a dada base. You can choose to copy structure, data and indexes, to copy structure and data, or to copy structure only. You can select fields (columns) to be copied, and select records (rows) to be copied. You can merge tables or break a table. The conversion of data types is performed automatically by Database Bridge.

 

Database Bridge provides versatile and efficient tools for the purpose of data comparison and transfer. It is capable of comparing data, transferring data, relocating data and deleting data. You can define the selection criterion for the data involved in the transaction. These data services work for both relational or flat data sources.

 

Database Bridge’s performance is excellent. Its cross DBMS data transfer speed is far above many similar products. Database Bridge can complete in minutes a cross DBMS data transfer job of million records, which would take hours with many other similar products. 

 

Database Bridge provides flat data source users with a powerful tool to perform checks on data integrity. Data from flat data sources, such as text files or spread sheets, is not reliable because it is not protected by an adequate data validation mechanism in its data source. Database Bridge provides a good validation tool for integrity check on data from flat databases. With this tool, you can easily define various kinds of validation rules, even rules to check uniqueness and rules to check the match of your data against a database table (a relation similar to FK-PK match in relational model). You can define as many rules as you want, use Visual Basic functions in your rules. You just define the rules, and Database Bridge does the hard work and tells you which records are bad and why they are bad. It is that simple.

 

Database Bridge provides users with good reusability. Not only can you do various jobs with it, but also you can save these jobs for future reuse. You define a job only once and run it as many times as you want. In addition, you can run your defined job at any chosen time, because Database Bridge provides a scheduler, which allows you to submit a job for execution at a later time.   

 

Database Bridge can serve as a universal interface to access almost every relational database and many flat data sources. It is a great help for people who are working in a multiple database environment. It is tedious, if not a burden, to get familiar with different database interfaces, to have them crowd your monitor’s screen, to switch from one interface to another. With Database Bridge, you stay with one interface and reach all your data sources. You can easily get information on database schema for each of your databases, issue regular queries to access a particular database, issue a distributed query to access multiple databases, present retrieved data in various kinds of ways, …  

 

Database Bridge is a universal management tool for distributed data in the sense that it does not come from a particular database vendor and does not limit its service to a particular database environment. It works fine as a data bridge for almost any relational databases and many non-relational data sources. For example, it can serve as a bridge to link a Oracle database and a Microsoft SQL database as well as a bridge to link a Microsoft Excel database, a Microsoft Access database to a IBM DB2 database.

 

 

Contact Information

 

Skyway Technology

Mail: Skyway Technology

         Milliken Wells

         P.O. Box 17528

         Toronto, Ont., M1V 5M5

         Canada

Web site: www.skywaytechnology.com

Email: contact@skywaytechnology.com