DRAFT

Omnidex Development Quick Reference

Development	C++	C#	Java	PHP	PLSQL	TRANSACT	Debug
Programs	OdxAdmin	OdxSQL	OdxNet	OdxAim	DSEDIT	DBINSTAL	Quick Ref
Interfaces	ODBC	JDBC	DB Procs

Omnidex SQL:	Overview	Statements	Functions	Examples	Quick Ref
OdxSQL:	Overview	Commands	Settings	Command Line	Quick Ref

Interfaces

Debugging

Debugging

Pre Version 5.1 Environment Catalog Syntax

Environment Catalog Syntax

Tutorials

Creating a small Environment on a Flat File

Simple Environment on Flat File

Example Programs

Language	Example
Java	Java JDBC Simple Connection and Select
PHP	PHP Simple Connection and Select
C++	Windows C++ Simple Connection and Select
C#	Windows C# Simple Connection and Select
TransactSQL	SQL Server TransactSQL Stored Procedure Example
PL/SQL	Oracle PL/SQL Stored Procedure Example

Main Development Components

Omnidex Development uses the following main components of the Omnidex Software.

Java Snapshot Application Steps

Install Omnidex on Snapshot data store.
Set up OdxNet Network Services.
Use OdxSQL to test set up, prototype and optimize queries.
Write Java Application.

Windows Snapshot Applications

Install Omnidex on Snapshot data store.
Set up OdxNet Network Services.
Use OdxSQL to test set up, prototype and optimize queries.
Write Java Application.

RDBMS Integration

Install Omnidex on RDBMS.
Use OdxSQL to test set up, prototype and optimize queries.
Write Stored Procedures using the RDBMS Stored Procedure Interface.
Run OdxAIM to generate Automatic Update Triggers.
Install Triggers.
Run OdxAim to monitor and process the triggered updates.

Omnidex Development primarily takes the form of developing either an ODBC or JDBC based application or using either SQL Server or Oracle Stored Procedures.

Applications have also been previously developed using the OmniAccess API (OA) and Client OmniAccess (CLOA) api. DISC recommends that all future Omnidex development use ODBC, JDBC or the Stored Procedure Interface.

Applications using Omnidex have been developed using:

Language	Example
Java	Java JDBC Simple Connection and Select
PHP	PHP Simple Connection and Select
C++	Windows C++ Simple Connection and Select
C#	Windows C# Simple Connection and Select
TransactSQL	SQL Server TransactSQL Stored Procedure Example
PL/SQL	Oracle PL/SQL Stored Procedure Example
C
Visual Basic
Cold Fusion
Microsoft Access
Microsoft Excel
MicroStrategy
Oracle Business Intelligence
SAP Business Objects
Activant Speedware 4th GL