This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
|
dev:home [2009/12/07 04:41] tdo |
dev:home [2016/06/28 22:38] (current) |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| {{page>:top_add&nofooter&noeditbtn}} | {{page>:top_add&nofooter&noeditbtn}} | ||
| - | <html><div align="center"><span style="color:red">DRAFT</span></div></html> | ||
| - | ====== Omnidex Development Quick Reference ====== | ||
| - | ^ Development ^ [[dev:odbc:examples:simpleselect | C++ ]] ^ [[dev:odbc:examples:csharp_simple_select |C# ]] ^ [[dev:jdbc:examples:simpleselect | Java ]] ^ [[dev:odbc:examples:php_select | PHP ]] ^ [[dev:dbprocs:oracle:sample_code | PLSQL ]] |^[[dev:dbprocs:sqlserver:sample_code | TRANSACT ]] ^ [[dev:debug | Debug ]] ^ | ||
| - | ^ Programs ^ [[programs:odxadmin:home | OdxAdmin ]] ^ [[programs:odxsql:home | OdxSQL ]] ^ [[programs:odxnet:home | OdxNet ]] ^ [[programs:odxaim:home | OdxAim ]] ^ DSEDIT ^ [[ dev:home | Quick Ref ]] ^ | ||
| - | {{page>:sql_bar&nofooter&noeditbtn}} | ||
| - | ===== Interfaces ===== | + | ====== Development ====== |
| - | * [[dev:odbc:home | ODBC ]] | + | ===== Introduction ===== |
| - | * [[dev:jdbc:home | JDBC ]] | + | |
| - | * [[dev:dbprocs:home | RDBMS Stored Procedure Interface ]] | + | |
| - | ===== Debugging ===== | + | |
| - | * [[ dev:debug | Debugging ]] | + | |
| - | ===== Example Programs ===== | + | The section discusses the techniques for developing Omnidex applications. This is most often read by Omnidex Developers. |
| - | ^ Language ^ Example ^ | + | |
| - | | Java | [[dev:jdbc:examples:simpleselect | Java JDBC Simple Connection and Select ]] | | + | |
| - | | PHP | [[dev:odbc:examples:php_select | PHP Simple Connection and Select ]] | | + | |
| - | | C++ | [[dev:odbc:examples:simpleselect | Windows C++ Simple Connection and Select ]] | | + | |
| - | | C# | [[dev:odbc:examples:csharp_simple_select | Windows C# Simple Connection and Select ]] | | + | |
| - | | TransactSQL | [[dev:dbprocs:sqlserver:sample_code | SQL Server TransactSQL Stored Procedure Example ]] | | + | |
| - | | PL/SQL | [[dev:dbprocs:oracle:sample_code | Oracle PL/SQL Stored Procedure Example ]] | | + | |
| - | ===== Main Development Components ===== | + | Choose from these topics: |
| - | Omnidex Development uses the following main components of the Omnidex Software. | + | |< 100% 35% 65% >| |
| + | | \\ **Omnidex SQL** || | ||
| + | |[[dev:sql:home|Omnidex SQL Quick Reference]] | A quick-reference guide to Omnidex SQL, including statements and functions. | | ||
| + | |[[dev:sql:statements:home|Omnidex SQL Statements]] | A guide to all Omnidex SQL Statements. | | ||
| + | |[[dev:sql:functions:home|Omnidex SQL Functions]] | A guide to all Omnidex SQL Functions. | | ||
| + | |[[dev:sql:qualify:home|Omnidex SQL Qualification Syntax]] | A guide to all Omnidex SQL Qualification Syntax. | | ||
| + | |[[dev:sql:examples:home|Omnidex SQL Examples]] | Examples of how to use Omnidex SQL in various situations. | | ||
| + | | \\ **Connection Strings** || | ||
| + | |[[dev:connections:home|Connection Strings]] | A guide to Omnidex Connection Strings. | | ||
| + | | \\ **ODBC Interface** || | ||
| + | |[[dev:odbc:home|ODBC Interface]] | A guide to using the Omnidex ODBC Interface, including sample programs. | | ||
| + | | \\ **JDBC Interface** || | ||
| + | |[[dev:jdbc:home|JDBC Interface]] | A guide to using the Omnidex JDBC Interface, including sample programs. | | ||
| + | | \\ **Logging and Debugging** || | ||
| + | |[[dev:debug:log|Omnidex Connection and Query Logging]] | A guide to logging and monitoring Omnidex connections and queries. | | ||
| + | |[[dev:debug:debug|Omnidex Debugging]] | A guide to debugging Omnidex applications. | | ||
| + | | \\ **Querying Metadata** || | ||
| + | |[[dev:metadata:home|Querying Metadata]] | A guide to interactively querying metadata from the Omnidex Environment File. | | ||
| - | * [[ programs:odxadmin:home | Omnidex Administrator ]] | ||
| - | * [[ programs:odxsql:home | OdxSQL ]] | ||
| - | * [[ programs:odxnet:home | OdxNet ]] | ||
| - | * [[ programs:odxaim:home | OdxAim ]] | ||
| - | * [[ dev:odbc:home | Omnidex ODBC Driver ]] | ||
| - | * [[ dev:jdbc:home | Omnidex JDBC Driver ]] | ||
| - | * [[ dev:dbprocs:home | RDBMS Stored Procedure Interface ]] | ||
| - | ===== Java Snapshot Application Steps ===== | + | {{page>:bottom_add&nofooter&noeditbtn}} |
| - | * 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. | ||
| - | |||
| - | * [[dev:odbc:home | ODBC ]] | ||
| - | * [[dev:jdbc:home | JDBC ]] | ||
| - | * [[dev:dbprocs:home | RDBMS Stored Procedure Interface ]] | ||
| - | |||
| - | Applications using Omnidex have been developed using: | ||
| - | |||
| - | ^ Language ^ Example ^ | ||
| - | | Java | [[dev:jdbc:examples:simpleselect | Java JDBC Simple Connection and Select ]] | | ||
| - | | PHP | [[dev:odbc:examples:php_select | PHP Simple Connection and Select ]] | | ||
| - | | C++ | [[dev:odbc:examples:simpleselect | Windows C++ Simple Connection and Select ]] | | ||
| - | | C# | [[dev:odbc:examples:csharp_simple_select | Windows C# Simple Connection and Select ]] | | ||
| - | | TransactSQL | [[dev:dbprocs:sqlserver:sample_code | SQL Server TransactSQL Stored Procedure Example ]] | | ||
| - | | PL/SQL | [[dev:dbprocs:oracle:sample_code | 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 | | | ||
| - | | ||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | |||
| - | {{page>:bottom_add&nofooter&noeditbtn}} | ||