Show pagesource
Old revisions

This is an old revision of the document!

DRAFT

Omnidex Development Quick Reference

Development C++ C# Java PHP PLSQL TRANSACT Debug
Programs OdxAdmin OdxSQL OdxNet OdxAim DBINSTAL DSEDIT OACOMP
QuickLinks Statements Functions OdxSQL

Interfaces

Debugging

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
 
Back to top
dev/home.1260160667.txt.gz ยท Last modified: 2016/06/28 22:38 (external edit)
Sitemap Recent Changes