BOI Software Entwicklung und Vertrieb GmbH

Phone: +43 (0) 732 / 736423 - 0

Spazgasse 4

Email: office@boi.at

4040 Linz, Austria

www.boi.at

Infrastructure

TABEX/4 functions for data transfer, copying and moving, importing and exporting and other tasks permit the unlimited distribution of table data in heterogeneous IT environments. Thus table data are available system wide for all IT procedures and for any other application.

Copying and Moving of Tables

Tables can be copied and moved within the database or across databases.

Migration of Table Data between Relational Databases

You have tables in relational databases and require them in another relational database on a different operating system?
You want to migrate table data of one database to a different database with different structure?

TABEX/4 offers you the tool to transport data between different relational databases. For example, you can maintain data stored in Oracle in DB2 or transport data from Informix to DB2.

Figure: Example for a migration from Informix to DB2

Using TABEX/4 utilities TABN02 (command SQLTAB) / TABN05, data of the source RDB (in the example: Informix) are buffered in a TABEX DB (in the example: TABEX_DBi). In most cases, datatype conversions are needed. Therefore, an application program must be implemented to adapt the datatypes and save the table in another TABEX DB (in the example TABEX_DBd). Using utility command SQLUPD, this TABEX_DBd is transferred to the target database (in the example: DB2). If the corresponding table does not yet exist in DB2, it can be created in the target database using utility TABN06.

Please contact our support, if you want to learn more about this feature.

 

Unlimited Data Transfer

By using TABEX/4 utility functions, data may be transferred between different data sources (e.g., TABEX tables, sequential files, tables from relational data bases such as DB2, Oracle, MS SQL Server, Informix, PostgreSQL, Mysql, ...). All combinations of source and destination are supported.

Import/Export of Tables

Many TABEX/4 customers use MS EXCEL and other programs for diagram generation, statistical analysis, presentations and reports, so there is a need to manage table data outside of databases.

With TABEX/4 this can be easily done.

The export of tables or the active table maintenance area enables the transfer of table data from databases into other applications, e.g. MS EXCEL, in order to edit them onward.

It is also possible to import changed data from MS EXCEL or other programs to TABEX/4 (again). The imported data can either replace the whole table or they can be added to the existing data. When the table is saved the imported data will be checked (check tables, RI checks, etc.).

Print

Table data and table selections can be exported as TEXT or PDF documents.

TABEX/4 Mail

The TABEX/4 Mail Program Interface enables sending of generated PDF or CSV files, logs of batch programs or any other data attached to e-mails.

Replication of Data

Automatic replication synchronizes databases and data spaces across platforms.

Advantages of the automatic replication:

  • central administration of data for different project areas
  • increased availability of data
  • offline access to local replicates
  • higher performance of read access (shorter response time)

Migration Packages

BOI GmbH offers migration packages for the table management systems SPITAB, TABSYS and VTAS.

 

» Migrations Packages

Success Stories

AirPlus has been using TABEX for 20 years.

Now TABEX/4 JAVA APPLICATION ENGINE has additionally been launched for audit-proof logging of the business processes by Java applications.

 

» read this success story

» more success stories