This document describes how to prepare Natural for its use with Software AG's Entire Access.
The following topics are covered:
Via Entire Access, Natural applications can transparently access multiple relational database management systems (RDBMSs), in both client-server and single-platform environments.
Entire Access has been designed to provide a common SQL-compliant application programming interface (API) for both local and remote database access. It represents a client-server solution for Software AG's database systems Adabas SQL Server and Adabas, as well as for various third-party products, for example, ODBC-compliant databases under Windows.
With Entire Access, a Natural user can access data in a relational database. In general, there is no difference between using Natural with Entire Access and using Natural with Adabas. Entire Access supports Natural DML and SQL statements which can both be used from within one Natural program accessing multiple database systems.
Natural converts Natural native DML and Natural SQL statements within Natural applications into calls to Entire Access, which performs the required data format translations and transfers these requests to the underlying database system via the appropriate database driver.
All operations requiring interaction with the database are performed by Entire Access. It supports local and/or remote databases and contains a series of database drivers, one for each supported RDBMS, so that multiple heterogeneous RDBMSs can be accessed concurrently from within the same Natural application.
For remote access, the transport media for SQL data are provided by Entire Net-Work, which establishes the communication link, or by TCP/IP.
Under Windows, Entire Access can be used to access either local ODBC-compliant databases and/or remote databases on Windows and UNIX hosts.
Note:
If you want to access remote databases, you also have to install and
use the Entire Access server component on the host platform; for further
information and prerequisites, see the Installation chapter of the Entire
Access documentation.
To be able to use Entire Access, you have to modify your global configuration file, establish a connection to the database(s) to be used, create database tables with the appropriate database tools, and generate a Natural data definition module (DDM) for each database table to be accessed by a Natural program.
To be able to work with Entire Access, you have to modify the global configuration file (default name: NATCONF.CFG) as follows:
To modify the global configuration file
Invoke the Natural Configuration Utility.
The Natural Parameter Setting window appears with the name of the parameter file currently active or edited displayed in the title bar.
Select the path Global Configuration File
/ DBMS
Assignments
in the tree view.
A dialog appears in which you have to specify the
DBID
parameter.
For all SQL databases that can be accessed via Entire Access, you
always specify the same DBMS type: SQL
.
Via the DBMS
parameter, you must then
establish the connection to the actual database as described in the following
section.
Note:
For each database you want to be accessed by Entire Access, you
must repeat the specification of the corresponding DBID
and DBMS
parameter.
Save the updated global configuration file.
The connection to the database(s) you want to work with must be established only once for each database. Subsequently, you merely have to log on to Natural and the database connection(s) will be established automatically.
Entire Access can support up to 7 different database drivers. Since the database drivers are reentrant, you can establish multiple separate connections to the same driver via a so-called database connect string.
The database connect string represents the DBMS parameter you or your system administrator must specify with the Natural Configuration Utility during the modification of your global configuration file. It consists of the following syntax:
dbms:[db-name][@server-number:host-name!driver] |
Syntax Element Description:
Syntax Element | Description |
---|---|
dbms |
dbms
is mandatory and specifies any supported driver; currently the following
drivers are supported under Windows:
For ODBC-compliant databases:
For remote database access:
For remote access, you have to connect the Entire Access network
component by specifying |
db-name |
For ODBC-compliant databases:
Note: For remote databases:
|
server-number |
server-number is
required for remote access only; see the Entire Access documentation for
further information.
|
host-name |
host-name is required
for remote access only; see the Entire Access documentation for further
information.
|
driver | driver
specifies the database driver to be used; see the Entire Access documentation
for further information.
|
To connect to an ODBC-compliant database with a data source called "sample", specify:
ODBC:sample
Now Entire Access is connected to the database(s) to be accessed. The
user ID of the default administrator is sag
.
To make Entire Access operational
Start your local ODBC-compliant database(s) in the usual way; for remote databases, refer to the Entire Access documentation.
Start Natural.
Entire Access can now be used and you can start a Natural session as usual.
To be able to work with Entire Access, you must create database tables or views using the appropriate tools provided by your database system(s).
To be able to access a relational database table or view with a Natural program, you must then generate a Natural data definition module (DDM) for the defined database table or view.
The DDM name must match the name of the corresponding table or view. Thus, you can create only one DDM for each table or view. It is recommended that the DDM name include the name of the table creator (owner) separated by a hyphen. The DBID in the DDM must correspond to the DBID assigned by the Natural Configuration Utility.
Once a DDM has been defined for a relational table or view, it is possible to access the data stored in this table or view by using a Natural program.
Entire Access translates the statements of a Natural program into SQL statements. It automatically provides for the preparation and execution of each statement.
In addition to the Natural native DML statements, Natural provides Natural SQL statements, which are described in the Natural Statements documentation; for further information, see also the Entire Access documentation.
For a description of how to create DDMs from relational database tables, refer to the section Creating DDMs in the Natural Editors documentation.