Legacy Data Manager

In order to use SQL to access a non-relational data source, for example VSAM or IMS, the data must first be mapped into a relational format. The mapping is typically done by the database administrator, and must be done once for each file that is to be accessed. The mapping is performed using the Legacy Data Manager, a Windows-based application.

The easy-to-use, GUI interface can be used to map the file manually, or if desired, existing COBOL copybooks can be used to automatically supply the file structure information. In either case, the mapping information is saved in a mainframe-resident catalog modeled after the DB2 catalog structure. All System 370/390 datatypes are supported, as are complex VSAM structures like multiple record types and repeating fields.

Shown below is a sample Legacy Data Manager screen shot that depict how files are mapped into a relational format:

The Legacy Data Manager is connected to the Legacy Data Server through the ViaSQL Gateway and ViaSQL Access Server. The Legacy Data Manager is also used to configure and administer the Legacy Data Server environment.

View the system requirements.