Sagent Demos Tight Interoperability With Microsoft's Data Warehouse Repository; Sagent Chosen to Present At Microsoft's Data Warehousing Workshop.REDMOND, Wash.--(BUSINESS WIRE)--April 22, 1998--Sagent Technology, Inc., provider of the leading turnkey solution for bringing data marts A subset of a data warehouse for a single department or function. A data mart may have tens of gigabytes of data rather than hundreds of gigabytes for the entire enterprise. See data warehouse. to the Web, demonstrated today the close interoperability of its data movement and data access technologies with the Microsoft Repository and Data Transformation Services Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. .
Microsoft will deliver these technologies later this year as part of SQL Server An earlier relational DBMS from Sybase and from Microsoft. Sybase introduced SQL Server in 1988 for various Unix versions. In that same year, with help from IBM, Sybase created an OS/2 version that Microsoft licensed and branded as Microsoft SQL Server. 7.0. Sagent's featured participation at the Microsoft Repository Data Warehousing See data warehouse.
data warehousing - data warehouse Workshop underscores its close relationship with Microsoft in its efforts to provide customers with the easiest, most cost-effective way to develop Web-enabled data marts.
"Sagent has always leveraged Microsoft technologies to give its customers the best data mart solution, and we will continue to do so as we deliver functionality that will complement all of the different capabilities in SQL Server 7.0," said Ken Gardner, Sagent's president and CEO (1) (Chief Executive Officer) The highest individual in command of an organization. Typically the president of the company, the CEO reports to the Chairman of the Board. . "Microsoft is going to establish a powerful data warehousing platform, and we will be right there with them to embrace and extend their technology where it makes sense for customers implementing data marts."
"Sagent offers an excellent upgrade path from the Data Transformation Services (DTS (1) (Digital Theatre Sound) A digital audio encoding system used in movie and home theaters. Popularized by the movie Jurassic Park, the six-channel (5. ), included with SQL Server 7.0, for users that need to create complex transformation processes or build star schemas A data warehouse design that enhances the performance of multidimensional queries on traditional relational databases. One fact table is surrounded by a series of related tables. Data is joined from one of the points to the center, providing a so-called "star query." See OLAP. ," said Steve Murchie, data warehousing product manager at Microsoft. "Committed third-party vendors like Sagent are critical to our strategy of making the Microsoft Data Warehousing Framework an open industry standard by providing SQL Server customers with a wide range of options when designing their data warehouse or data mart."
Sagent Leverages the Microsoft Repository and DTS
Sagent demonstrated integration with the Microsoft Repository which allows users to easily leverage both product sets to deliver a cost-effective and timely data mart solution. This integration gives users the ability to share data warehousing or data mart metadata and convert Microsoft's Data Transformation Services (DTS) packages into Sagent Data Flow plans.
Sagent users can import and export metadata between the Sagent Repository and the Microsoft Repository from within Sagent Design Studio, Sagent's visual environment for building and providing access to data marts. This metadata can include descriptive information about data sources and targets as well as information about transformation processes. An open exchange of metadata promotes easy interoperability between different vendors' data warehousing products. Users can leverage this interoperability to create unique solutions for their data mart implementations.
The value of this interoperability is demonstrated by the Sagent Data Mart Solution's ability to complement Microsoft's DTS, their transformation product. Users can easily bring a basic DTS package into Sagent and then extend it with Sagent's powerful transformation capabilities. With a transformation environment that combines pre-built functionality and sophisticated customization options, Sagent's data movement technology is ideal for SQL Server users that require more complex transformations, such as the loading of star schema-based data marts. Sagent simplifies common loading tasks such as synthetic key generation, key lookup A data search performed within a predefined table of values (array, matrix, etc.) or within a data file. to confirm fact and dimension table data integrity, and time dimension creation.
Sagent's Microsoft Heritage
From its inception, Sagent has let organizations take maximum advantage of the price/performance benefits of the Microsoft platforms when deploying data marts. Sagent's client products support Windows 95 and Windows NT (Windows New Technology) A 32-bit operating system from Microsoft for Intel x86 CPUs. NT is the core technology in Windows 2000 and Windows XP (see Windows). Available in separate client and server versions, it includes built-in networking and preemptive multitasking. , and the Sagent application server runs on Windows NT. In June 1995, Sagent was selected as one of the initial vendors to license Visual Basic for Applications, and in May 1997, Sagent was chosen to be a member of Microsoft's Alliance for Data Warehousing.
About Sagent Technology
Sagent Technology was founded in June 1995 to make business data more usable by bringing it closer to decision-makers. The Sagent solution lets organizations bring data marts to the Web quickly and cost-effectively with a turnkey offering that includes best-of-breed products and comprehensive professional services (job) professional services - A department of a supplier providing consultancy and programming manpower for the supplier's products. .
Sagent is a privately-owned company that was co-founded by Ken Gardner and John Zicker. Its customers include BellSouth, Cellstar, JP Morgan and Mastercard, and the company has strategic relationships with Oracle Corporation, Microsoft Corporation (company) Microsoft Corporation - The biggest supplier of operating systems and other software for IBM PC compatibles. Software products include MS-DOS, Microsoft Windows, Windows NT, Microsoft Access, LAN Manager, MS Client, SQL Server, Open Data Base Connectivity (ODBC), MS Mail, , and Ralph Kimball Ralph Kimball, is an author on the subject of data warehousing and business intelligence. He is known for long-term convictions that data warehouses must be designed to be understandable and fast. Associates. Sagent is funded by Crosspoint Venture Partners, El Dorado El Dorado, legendary country of South America
El Dorado (ĕl`dərä`dō, –rā`–) [Span.,=the gilded man], legendary country of the Golden Man sought by adventurers in South America. Ventures, Greylock Limited Partnerships and U.S. Venture partners. -0-
Note to Editors: Sagent's web site is located at www.sagenttech.com.
Sagent and Information Studio are registered trademarks of Sagent Technology, Inc. Sagent Design Studio and the Sagent logo are trademarks of Sagent Technology, Inc. All other trademarks are the property of their respective owners.
CONTACT: Sagent Technology, Inc.
Perry Mizota, 650/496-3109
Cathy Wright, 650/595-1871