I'm pleased to announce that Attivio has taken a huge step forward in further extending our Unified Information Access capabilities to the traditional business intelligence/data warehousing world. In addition to our simple query language and advanced query language with industry-leading enterprise search and UIA JOIN capabilities, Attivio now offers customers the ability to issue SQL queries against Attivio's Active Intelligence Engine (AIE).

This new module means that if you want to query your email and CRM records by keyword or report on them using SQL statements, you can do so with a single information access system. By extending our query support to SQL, we are now more fully addressing the spectrum of information access from keyword search queries to SQL reports and opening up AIE to a whole new audience.

Unified Information Access is not just the indexing of structured and unstructured content; it's also providing the full range of structured and unstructured query capabilities, from keyword search to reporting. AIE previously enabled traditional "structured" data reporting via its advanced query language, but with the addition of SQL, a whole ecosystem of customers, users and tools can easily begin realizing the benefits of a single UIA repository.

The Beta release provides a subset of SQL functionality, but some key syntax elements are:

• SELECT (Field Aliases and Wildcards)

• FROM (supports aliasing)

• WHERE

  • Equality

  • Is Between/Is Not Between

  • Greater Than/Less Than

  • [Not] In

  • Is [Not] Null

  • Nesting of AND/OR Conditionals

• JOIN (ANSI) (INNER and OUTER)

• ORDER BY (Single/Multiple Field Asc/Desc)

Simple Search

Advanced Search

SQL Search - Beta

AIE's capabilities as a true UIA platform allow us to provide special SQL operators that enable our customers to select and filter SQL results with the full power of AIE's simple and advanced query languages.

Join our Beta Program

We're still accepting applications to our beta program; so if you're interested in getting a first look at this cutting-edge capability, please email This e-mail address is being protected from spambots. You need JavaScript enabled to view it .

We look forward to hearing from you!

TrackBack URI for this entry

Comments (0)