Sagent OpenLink. (Database/Network News & Products).Sagent OpenLink, is a new product 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 utilise 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 incorporate analytics into 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. .
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.