https://www.omnidex.com/docs/v54/ 2026-08-03T11:32:51+0000 https://www.omnidex.com/docs/v54/ https://www.omnidex.com/docs/v54/lib/tpl/simple/images/favicon.ico text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:constraints&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Constraints and Indexes Table constraints and indexes from the underlying database should be declared in the Omnidex Environment File. Omnidex uses primary and foreign key table constraints to understand the nature of the data and to optimize table joins. Declaring primary keys for a table also allows Omnidex to fulfill more querie… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:databases&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Databases The CREATE DATABASE statement is used to declare a database within an Omnidex Environment File to be accessed through ODBC. This statement can either be issued directly, or it can be extracted from the database using the EXTRACT statement as discussed in the previous section. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:datatypes&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Datatypes Omnidex supports most ODBC datatypes; however, care must be taken when mapping the ODBC datatypes to Omnidex. Omnidex has very limited support for Unicode datatypes, also known as National Character datatypes or Wide Character Set datatypes. Omnidex can retrieve and return these datatypes, but cannot index beyond the st… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:environments&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Environments The Omnidex Environment File contains metadata that describes the database and the Omnidex configuration. This includes the following connection and schema information for the underlying database: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:example&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Example The following example shows Omnidex on a simple database accessed through a generic ODBC driver. The Omnidex Environment File is displayed below; however, the entire example can be downloaded as a ZIP file at the following link: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:home&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Overview Omnidex can be deployed directly against any database that provides a standard ODBC driver. Omnidex retrieves and indexes the data by issuing standard ODBC calls, and queries read directly from the database as needed. This approach allows Omnidex to work alongside a wide variety of databases, providing a high-performance qu… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:queries&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Queries The Omnidex SQL Engine will optimize queries to take advantage of the Omnidex indexes. Many queries can be fulfilled entirely within the Omnidex indexes. This is especially true for queries that request counts or aggregations from one or more tables. Even queries that return columns of data can be completed using the Omn… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:tables&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Tables The CREATE TABLE Statement The CREATE TABLE statement is used to declare a table or view within an Omnidex Environment File to be accessed through ODBC. The Omnidex Environment File will contain a declaration for each table or view to be accessed, and will correlate all of the schema information between Omnidex and ODBC, inc… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:odbc:updates&rev=1467153531&do=diff Integration: Relational Databases Generic ODBC Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Updates Omnidex is primarily used on read-only databases; however, Omnidex can also be used on read-write databases. Omnidex supports the INSERT, DELETE, and UPDATE SQL statements. There are several restrictions that administrators must be aware of before deciding whether to use Omnidex on a read-write database: