https://www.omnidex.com/docs/v54/ 2026-04-29T12:57:55+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:sqlserver:constraints&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- SQL Server Constraints and Indexes SQL Server table constraints and indexes 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 queries solely in… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:databases&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Databases The CREATE DATABASE statement is used to declare a SQL Server database within an Omnidex Environment File. This statement can either be issued directly, or it can be extracted from SQL Server 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:sqlserver:datatypes&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Datatypes Omnidex supports most SQL Server datatypes; however, care must be taken when mapping the SQL Server datatypes to Omnidex. Omnidex accesses SQL Server using the SQL Server ODBC Connector, and so the datatype correlations will follow the ODBC standard. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:environments&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Environments The Omnidex Environment File contains metadata that describes the SQL Server database and the Omnidex configuration. This includes the following connection and schema information: text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:example&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Example The following example is a simple database using a SQL Server database. 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:sqlserver:home&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Overview Omnidex can be deployed directly against a Microsoft SQL Server database. Omnidex retrieves and indexes the SQL Server data, and queries read directly from the SQL Server database as needed. This approach allows Omnidex to work alongside SQL Server, providing a high-performance query environment for applications. text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:queries&rev=1467153531&do=diff Integration: Relational Databases SQL Server 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 Omnid… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:tables&rev=1467153531&do=diff Integration: Relational Databases SQL Server Overview | Environments | Databases | Tables | Constraints | Datatypes | Queries | Updates | Example ---------- Tables The CREATE TABLE Statement The CREATE TABLE statement is used to declare a SQL Server table or view within an Omnidex Environment File. The Omnidex Environment File will contain a declaration for each SQL Server table or view to be accessed, and will correlate all of the schema information between Omnidex and SQL Server, inclu… text/html 2016-06-28T22:38:51+0000 Anonymous (anonymous@undisclosed.example.com) https://www.omnidex.com/docs/v54/doku.php?id=integration:rdbms:sqlserver:updates&rev=1467153531&do=diff Integration: Relational Databases SQL Server 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: