Sagent OpenLink. (Tools).Sagent have announced the availability of Sagent OpenLink, that allows any ODBC (Open DataBase Connectivity) A database programming interface from Microsoft that provides a common language for Windows applications to access databases on a network. or JDBC-compliant software application to use the analytical power of Sagent's Data Access Server. Business analysts who work with business intelligence tools such as Actuate, Brio (Brio Technology, Palo Alto, CA, www.brio.com) A software company founded in 1989 and acquired by Hyperion Solutions Corporation in 2003 that specialized in enterprise analysis and reporting programs that run on several platforms. , Business Objects, Cognos, Crystal Decisions and Microsoft Excel (tool) Microsoft Excel - A spreadsheet program from Microsoft, part of their Microsoft Office suite of productivity tools for Microsoft Windows and Macintosh. Excel is probably the most widely used spreadsheet in the world. Latest version: Excel 97, as of 1997-01-14. can now use Sagent to transparently incorporate advanced analytics into their existing reports and business performance management solutions. Application developers can use Sagent OpenLink to query information from data warehouses and heterogeneous operational systems, then integrate, transform and deliver architected data sets that are fully accessible via SQL SQL in full Structured Query Language. Computer programming language used for retrieving records or parts of records in databases and performing various calculations before displaying the results. . Comment: Companies have invested heavily in query and reporting and OLAP (OnLine Analytical Processing) Decision support software that allows the user to quickly analyze information that has been summarized into multidimensional views and hierarchies. OLAP tools are used to perform trend analysis on sales and financial information. tools, and often employ multiple solutions across the enterprise. However, these front-end BI tools can only access a single data source at a time and have analytic capabilities that are restricted by physical database schemas. When combined with the Sagent platform, these BI tools become powerful analytic applications, enabling users to access data from multiple sources and calculate new metrics for their analyses, such as profitability forecasts, customer segmentation and time-period, variances. The Sagent Data Access Server and Sagent OpenLink provide strategic leverage to the BI development lifecycle by allowing business users to validate additions to analytical applications before the underlying databases or MOLAP See OLAP. cubes are changed. www.metagroup.com |
|
||||||||||||||||

Printer friendly
Cite/link
Email
Feedback
Reader Opinion