Unified Information Access Blog

Welcome to Attivio's Unified Information Access Blog. Join us for discussions on topics ranging from enterprise search solutions, information access insights, Agile software development methodology to programming with Java. We hope you'll find the articles informative and participate in the discussions by leaving a comment.

Share


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

ssui-basic.png

Advanced Search

ssui-advanced.png

SQL Search - Beta

ssui-sql-beta.png

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(0)
Comments (0)add comment

Write comment
smaller | bigger

security image
Write the displayed characters


busy

SUBSCRIBE

blue-rss-icon.png

Enter your email address:

 

Connect with Attivio

ico_attivio_spiral.jpg facebook-Icon.png twitter-icon.png

Contact Us:
+1.857.226.5040

Recent Posts

UIA: Boosting Customer Loyalty (Or How NOT to Annoy Your Customers)

I am in Tel Aviv enjoying a beautiful summer afternoon with a new customer when my mood is altered by a credit card snafu. Back in the states, a wary...
Read More...

Clash of the Titans: Price and Performance for Data Warehousing and Analytics

Why are all the mega technology vendors suddenly so focused on next generation data warehousing and analytics? Primarily, it's because Oracle wants to...
Read More...

Enriching Unified Information Stores with Text Analytics

Too often getting access to all the relevant business information we need has forced us to undertake a journey across multiple sources, using different...
Read More...
  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8