Home

Getting Started

Utilities

Indexing

Omnidex

Development

Tutorials

Quick Links

 

Utilities

DSEDIT

Info

Query

SQL

Disconnect

 

DSEDIT

Create a Data Source

Edit a Data Source

Test a Connection

Check the Server

Data Source Type

Data Source Name

Environment Info

Server / Host

ODBC Options

Sample Data Source

 

Test a Connection

To test a connection, click "Connect" from the Edit Data Source window. DSEDIT will establish two connections to the Omnidex Environment Catalog, one through the Omnidex Client Omnidex Access API (CLOA) and one through the Omnidex ODBC Gateway Interface.

Screen ShotWhen the connections are successfully established, you are given four options to choose from:

  • Info - See database info
  • Query - Query the indexes
  • SQL - Execute a SQL statement
  • Disconnect - Terminate both connections

 

Screen ShotInfo

Info displays structural information about the connected environment. This includes tables and columns, native indexes, Omnidex MDK and ASK indexes, and parent child relationships as defined in the Omnidex Environment Catalog. This information is obtained through the CLOA connection.

 

Screen ShotQuery

Query allows you to pass criteria to columns installed with Omnidex indexes to test the indexes through the CLOA connection.

First you are prompted to choose a table to query. (Joins are not allowed in this test.)

Next, a list of indexed columns and input text boxes is displayed, allowing you to enter criteria for one or more column. The qualified records are retrieved and displayed in the grid at the bottom of the screen.

 

Screen ShotODBC SYSTEM Data Source for Windows ODBC applications

SQL allows you to directly enter and execute SQL statements to test the ODBC connection. The qualified records are retrieved and displayed in the grid at the bottom of the screen.

 

Disconnect

Disconnect terminates both connections and returns you to the previous window.

 

Top