Remote data storage with access via standard interfaces

Add-on products such as SESAM-DBAccess (JDBC interface) or the ADO.NET interface can access Windows systems on SESAM/SQL databases, thus allowing the databases to be processed and updated. The data can, for example, be read into a spreadsheet, or addresses located in the database can be used in a word processing program for the creation of form letters.

The server and client components of SESAM-DBAccess are supplied with SESAM/SQL and do not have to be ordered separately.

Remote access with ADO.NET

SESAM/SQL-Server supports the ADO.NET interface defined by Microsoft (ActiveX Data Objects) for Windows systems to communicate with database systems in the client/server environment.

Via the ADO.NET driver, which is supplied together with SESAM/SQL-Server, you can implement database-independent accesses to SESAM/SQL from the .NET environment in Windows.

Webserver with connection to SESAM/SQL

For FUJITSU Servers of the BS2000 SE Series, a PDO driver is offered on an Application Unit under LINUX for the PHP interface to an Apache Webserver.

Accesses to SESAM/SQL databases can be performed in PHP websites and scripts via this PDO driver.

The PHP code is executed solely on the Server Unit. It remains hidden from the web user. Only the HTML code is transferred to the client. This satisfies the more stringent security requirements.

In addition to this new PDO driver, the PHP access functionality is, as previously, offered via an Apache Webserver under POSIX in BS2000.

Taking existing SESAM applications onto the Internet/Intranet: WebTransactions

Thanks to WebTransactions, it is an easy matter to make existing SESAM/UTM applications web-compatible. It is particularly easy in the case of applications that were created using DRIVE.

WebTransactions has already been successfully launched on the market and has a wide variety of uses in the integration of business applications and the associated data on the World Wide Web.

WebTransactions enables the following:

• host applications and data can be integrated unchanged into the Internet, or an Intranet or Extranet

• the host application's screen forms can be improved and rendered more attractive

• the host application can be adapted to meet specific needs by merging or extending dialog steps (dialog reengineering)

• it is even possible to merge multiple applications under one web interface and run these in parallel

Currently, all mainframe applications on BS2000 and MVS systems and OLTP applications with openUTM on BS2000, UNIX systems and Windows are supported.

Java: the SESAM/SQL-Server JDBC interface

The Standard Call Level Interface for Java applications, Java Server Pages, Java Servlets, and Java Applets when accessing SQL databases is JDBC (Java Database Connectivity). Java accesses that are independent of the database can run with SESAM/SQL-Server via the JDBC interface. Consequently, external Java applications can also be used with SESAM/SQL-Server.

SESAM/SQL-Server offers the JDBC functionality according to the JDBC standard V6.0. The corresponding drivers are present in SESAM/SQL-Server and are supplied on a volume together with SESAM/SQL-Server. They are type 4 drivers, i.e. they are “nativeprotocol fully Java technology-enabled drivers”. Compared to other types such as “ODBC/JDBC bridges” and “partly Java technology-enabled drivers”, this has the advantage that no binary code has to be installed on the client machine.