SQL Anywhere for Reporting & Analytics

SQL Anywhere offers you departmental reporting and analytics. And better yet, because SQL Anywhere uses the same SQL engine as Sybase IQ, you can easily migrate to the No. 1 column-based analytics server proven to scale up to one petabyte of data.

SQL Anywhere gives you the tools to:

Create customized applications that benefit from advanced database features and data interface
Leverage GUI applications to build reports and analyze data
Integrate SQL Anywhere within existing IT environments, replicating data from production databases in order to offload reporting

Develop with Enterprise-Class Features	Advanced OLAP functionality including rollup, recursive union, index union and intersection. Advanced features such as full-text search, regular expressions and materialized views. Web Services interface through built-in HTTP server.
Analyze Data and Build Reports with GUI Tools	Use Sybase PowerDesigner Physical Data Model to build schemas. Generate information ready reports with Sybase InfoMaker. Design interactive reports with MicroStrategy, Crystal Reports, BIRT Report Designer, and QlikView 9. SL Enterprise RTView certification with Sybase IQ and SQL Anywhere SL Enterprise RTView certification with Sybase ASE Import data directly into Excel.
Integrate into Existing Environments	Replicate data from operational database servers, including ASE, Oracle, SQL Server, DB2, MySQL and SQL Anywhere. Mirror existing SQL Anywhere database for separate reporting server. Easily migrate to Sybase IQ, the world's No. 1 column-based analytics server.

MORE INFORMATION

NEXT STEPS

RESOURCES

Getting Started
Features & Benefits
Data Sheets
Technical White Papers
Downloads

FEATURES & BENEFITS AT A GLANCE

DEVELOP WITH ENTERPRISE CLASS FEATURES	Advanced OLAP functionality including rollup, recursive union, index union and intersection Advanced features such as full-text search, regular expressions and materialized views Web Services interface through built-in HTTP server
ANALYZE DATA AND BUILD REPORTS WITH GUI TOOLS	Use Sybase PowerDesigner Physical Data Model to build schemas. Generate information ready reports with Sybase InfoMaker. Design interactive reports with MicroStrategy, Crystal Reports, BIRT Report Designer, and QlikView 9. SL Enterprise RTView certification with Sybase IQ and SQL Anywhere SL Enterprise RTView certification with Sybase ASE Import data directly into Excel
INTEGRATE INTO EXISTING ENVIRONMENTS	Replicate data from operational database servers, including ASE, Oracle, SQL Server, DB2, MySQL and SQL Anywhere Mirror existing SQL Anywhere database for separate reporting server Easily migrate to Sybase IQ, the world’s No. 1 column-based analytics server.

DOWNLOAD TRIAL