tcACCESS
  Task
  Technology
Architecture
SQL Technology
Features
Areas of Use
FAQ
  Mainframe Systems
  Workstation Systems

tcACCESS live

How our customers use tcACCESS in production !

more

Ask for a free of charge trial installation.

Tel.: ++49-89-4619930

tcACCESS – SQL Technology

Views      Join Technology      Mainframe access to Open System Databases 

Join Technology

Simple combination of different data sources:
tcACCESS supports "Joins". Multiple data sources (i.e. VSAM, DL/I and DB2) can be joined in one query. The identical treatment of DB2 resources and non-relational data sources offers data access strategies not easily available before.

Joins between mainframe-data and Open System-data:
tcACCESS supports the combined processing of mainframe data and Open System data using SQL statements. For example: VSAM and ORACLE-data can be joined in real-time and be processed by an EXCEL-spreadsheet, or a mainframe application can process an SQL statement that selects data from an IMS- and an ORACLE database.


SQL to non-relational data sources:
Using the Structured Query Language (SQL) to access non-relational data sources makes it easy for a programmer or end user to access mainframe data. 
 

Areas of use

He or She doesn't need to be a mainframe specialist. This allows easy access to legacy file structures from any workstation application (i.e. Back Office solutions, Database Management Systems, Decision Support Systems).

tcACCESS supports the „View Concept“ which guarantees that only the data the end-user is authorized to work with will be available. The data can come from different sources but will be presented like a relational table.
 
Features:
Transparent data joins for the application developer and end-user
Data security: only fields relevant to the end user are part of a the joined view
Performance: Optimized access strategy is part of the join
Cross platform data joins
Joins can be centrally stored as a view

 

TOP

 

 



NEWSLETTER

Subscribe B.O.S. Newsletter   

NEWS

tcVISION Version 4 available 

Julius Blum GmbH:
tcVISION moves data between DL/I, DB2 for z/OS and DB2 for LUW 

Vereinigte Informationssysteme Tierhaltung (vit): 
Bi-directional replication between ADABAS and ORACLE 

City of Leipzig: 
Bidirectional integration between IMS and Open Systems 

YAMPONG Corporation: 
the new B.O.S. Software partner in Taiwan 

CUSTOMERS

EVENTS

B.O.S. will present the tcVISION solution for the Real-time Synchronization / Replication of IBM-Mainframe data at the CICS/TS Working Group in Heidelberg from April 21 to 23, 2010 

B.O.S. Software will attend the Spring conference of GSE for z/VSE, z/VM and Linux on System z in Würzburg, Germany from April 19 to 21, 2010 

On December 10, 2009, B.O.S. presented a paper about their IDMS synchronization solution at the IDMS User Group Meeting in Bruxelles. The paper covers areas of bi-directional synchronization of IDMS-data, migration aspects and more