Learn More
Search site for:
News »
Scroll Up for Recent News
APPX 5.4.5 Available
APPX 5.4.5 is available for download from..

[Read Full Article]


APPX 5.4.4c Available
APPX 5.4.4c is available for download from..

[Read Full Article]


APPX 5.4.4 Available
APPX 5.4.4 is available for download from..

[Read Full Article]


APPX 5.4.3 Available
APPX 5.4.3 is available for download from..

[Read Full Article]


Amsterdam 2015 Conference Presentations available
We received some good feedback from the..

[Read Full Article]


CWI Announces Amsterdam Appx Training/Conference
We are pleased to announce an Appx Training..

[Read Full Article]


CWI Announces Appx Training
We are pleased to announce an Appx Training..

[Read Full Article]


Appx Software Announces New Price List Effective May 1, 2014
ASI has a price list effective May 1, 2014 ..

[Read Full Article]


Reconnect with Appx - Conference April 7-11
ASI has announced an upcoming conference April 7-11 in Atlanta...

[Read Full Article]


End of Support for 4.2.x Approaching
Due to the difficulty in supporting old releases and ...

[Read Full Article]


Amsterdam Presentations and Pictures Available!
We received some good feedback from the customers...

[Read Full Article]


Amsterdam Conference Registration Open!
Registration is now open for our Amsterdam Conference...

[Read Full Article]


Panama Conference A Success!
The Appx Conference held in Panama Feb 20-22 was well received...

[Read Full Article]


Panama Conference Registration Open!
Registration is now open for our Panama Conference...

[Read Full Article]


Appx Conferences in 2013!
Following the recent release of APPX 5.2, CWI is pleased to announce....

[Read Full Article]


Appx 5.2 Available
ASI has announced the availability of APPX release 5.2....

[Read Full Article]


Supported Releases
Release 5.1 of Appx is well on the way and ....

[Read Full Article]


APPX Conference Update
The Conference and Training session is over now....

[Read Full Article]


APPX 20th Birthday Celebration and Conference
ASI is pleased to announce the APPX 20th Birthday Celebration....

[Read Full Article]


Panama Conference in 2011
The Appx Release 5 Training and Conference was well attended...

[Read Full Article]


ASI Launches new Beta Progam
Appx Software, Inc has launched a new beta program ...

[Read Full Article]


Appx 5.0 Released!
The long awaited Release 5 of Appx is available ...

[Read Full Article]


Appx 5.0 Beta for Windows is Ready!
The Windows version of Appx Release 5.0 Beta is ready...

[Read Full Article]


Appx 5.0 Linux Beta is Ready!
Appx Release 5.0 Beta is ready. This Release includes ...

[Read Full Article]


Caylx Retires from Distribution
Following 33 years of working with the SPEED I, SPEED II and APPX...

[Read Full Article]


Appx Blog
Appx Blog Online
ASI has started a blog! This is an excellent way...

[Read Full Article]


Appx Conference 2007
We're pleased to report that our first European APPX Conference proved to be...

[Read Full Article]


Appx Conference 2007
Still haven't decided if the Appx Conference is for you? First of all, it's a great way...

[Read Full Article]


CWI Hosts European Conference
For some years now, ASI has been hosting tremendously successful APPX conferences in the USA...

[Read Full Article]


4.2.a Patch
ASI announces the APPX 4.2.a Patch Release is now available for download ...

[Read Full Article]


New Registration Format
ASI provides a new format for emailed APPX registrations. Registrations are now being sent as text file attachments to...

[Read Full Article]


Conference Results
Another conference is over, and once again it provided an excellent opportunity to network, learn and socialize with VARs and customers from around the world...

[Read Full Article]


Appx Conference
You are cordially invited to join your APPX colleagues and friends at the newest "episode" of the bi-annual conference, called "APPX EX-ZOO-BERATION 2006"!...

[Read Full Article]


Minicom Joins CWI
CWI is delighted to welcome Minicom Software House Ltda, located in Brazil, to its reseller network!

For over 25 years, Minicom's team of consultants has been involved in the development and...

[Read Full Article]


Sadden Joins CWI
Sadeen Computerized Systems is an integrated solutions provider which has been offering management control software, security systems and access control software to SMEs for a number of years. Now, however...

[Read Full Article]


SWS Joins CWI
CWI is pleased to welcome SWS Software Service in Austria to its reseller network! SWS has been a very successful SPEED II reseller since 1983 and has been working with APPX since...

[Read Full Article]


Sintec Joins CWI
CWI is pleased to welcome Sintec, S.A. de C.V. from Mexico to its reseller network!

[Read Full Article]


Scroll Down for Archived News


A | B | C | D | E |F | G | H | I | J | K | L | M | N | O | P
Q | R | S | T | U | V | W | X | Y | Z


APPX and Oracle

Release 4.1 of APPX contains a number of enhancements when using APPX with RDBMS systems, such as Oracle. They include partial record I/O, table caching and better control over when transactions are committed to the database. This page discusses how to make the best use of the enhancements. Note that RDBMS support is an extra cost feature of APPX, and you will require a new registration that activates this feature.


Configuring APPX and Oracle

The first step is to configure APPX to work with your RDBMS. In this example, we'll use Oracle. As of release 4.1.3, Oracle is the RDBMS that works with the new changes, but other RDBMS's are planned.

First, you have to install Oracle. The installation is generally simple, if you know what you're doing. If you haven't installed Oracle before, you'll need help. One book we recommend is 'Oracle 8i for Linux Starter Kit', ISBN 0-07-212442-3. This book also includes Oracle for Linux.

Once you have Oracle installed, you can begin configuring APPX to use Oracle as it's RDBMS. APPX 4.1.3 is compatible with Oracle 8. The engine will run against an Oracle 7 database, but the Oracle 8 client must be used. You must also set the environment variable APPX_ORACLE7_SERVER=1 so that the APPX engine will know how to properly access the database.

There are two environment variables that are required to run Oracle. By the time you have installed Oracle, you will know what these variables should contain.

ORACLE_HOME = <path name where oracle is installed>
ORACLE_SID= <database name>

You can set these in the $APPXPATH/appx.env file.

Next, you must use the proper APPX engine. In your /linkable directory, you should see a file called 'appx.oracle'. Replace your existing 'appx' engine with this engine instead. Remember that for Unix systems, the engine must be owned by user 'appx' and have the sticky bit set. If you don't have a linkable directory, or an appx.oracle engine, then you can download it from the downloads section at http://www.cwi-appx.com. Download the 'linkable' for your platform and install it using the 'install.sh' script. It is not necessary to reinstall the main APPX environment if you are just installing the linkable.

Troubleshooting note: If APPX complains about a missing library when you try to run it, make a note of the library name and search your system for that library. Chances are it is there, just not in the location APPX expects. Once you find it, try copying it to the /lib directory (or wherever libraries are kept on your system).

Once in APPX the first step is to create a File Management System group for the Oracle database. From the startup menu, select System Administration, then Configuration and File System Groups. Add a new group. You can call the group anything you like. The FMS type for Oracle is 5. You can press help on this field to see the type for the other supported databases. You can leave the path blank. Once you press enter, you will be prompted for the following:


     

The only thing that must be filled in is the table naming scheme. Table Naming Scheme is the field used to set the way the tables will be named in Oracle. Since each table must have a unique name in Oracle and APPX allows you to have the same file name in multiple companies, you must have a way to identify the files in each company. Oracle does not support multiple databases and all file names are stored in a single Oracle table.

For example, if your APPX installation has two companies, like a production and test database, and each has a CLIENT file pointing to an Oracle table, Oracle would not recognise one from the other. To Oracle, CLIENT is CLIENT. On the APPX side, something must be done to make the two unique to Oracle. The Naming Scheme is one way to do that. You can type an identifying scheme, or select the Hint option to the right side of the screen. The Hint option will display a few common naming conventions from which you can choose.

The remaining fields would be of more interest for an Oracle Administrator. We can leave them blank. Once you press Enter, the FMS group is saved.

Next, call up the FMS group in change mode. We have to set the identity for this FMS group. Identities are used to access external databases like Oracle, Sybase, or APPX/NET. If no Identities are entered at all, APPX will attempt to make the connection using the system id of the current user. The password will be taken from the user's Auxiliary Password entry.

An Identity can be entered for each user in APPX. Enter the APPX user id and, if you would like, an expiration date. There is also a flag to indicate if the Identity is active or not. When enter is pressed a screen will pop up that will allow you to enter the login id and password to be used for the connection. An Identity with no user id can be created as a kind of global identity. If APPX cannot find an entry matching the user id then the blank user Identity information will be used.

The FMS Group is now set up. When files are defined in APPX, the FMS group can be specified so that the file will be created as an Oracle table.

Go to the Database Management Menu and select the database and application you want to use. If you have data you want to import into Oracle, then first export everything from the APPXIO tables.

Then choose File Specifications and begin entering the FMS type and name you defined earlier. Note that APPX does not support consecutive or one-record files in the Oracle interface. Those types of files must be left as APPXIO files.

You can also override other attributes on a file by file basis via the File Attributes popup, and you can override APPX's default selections for column names and field types via the Field Overrides popup. Once you have set the FMS groups on all desired files, run 'Create Files'. This will create the empty tables in Oracle.

Once that is done, you can run 'Import' to load the data you exported previously.

Next »




For additional information, contact tips@cwi-appx.com

[back to top]