SoftArtisans

Last updated

SoftArtisans is an American company that develops active server components and reporting solutions[ buzzword ] for Microsoft web development environments such as ASP.NET. The company has two products: OfficeWriter, a .NET-based Microsoft Office reporting solution[ buzzword ] and FileUp, a client-server-server HTTP file transfer provider.

Contents

SoftArtisans was founded by David Wihl in 1996 and is headquartered in Watertown, Massachusetts. The company currently has around 30 employees and has been listed on the Inc. 500 and North America Fast 500. [1] [2] In 2007, Microsoft acquired all the intellectual property of OfficeWriter. [3]

Microsoft Acquisition

In 2007, Microsoft announced the acquisition of all the intellectual property of OfficeWriter as part of their Business Intelligence expansion. OfficeWriter functionality was partially integrated into SQL Server 2008. [4]

Products

OfficeWriter: OfficeWriter is a server-side reporting tool that generates Excel spreadsheets and Word documents over the Web from various data sources without Microsoft Office on the server. [5] Users create .xls and .doc templates for Excel spreadsheets and Word documents, store them on the server, and write a short .NET script that allows the template to be populated with data. [6] Used as a renderer within SQL Server 2008, OfficeWriter also generates Report Definition Language (RDL) files that preserve Excel features. [7]

FileUp: FileUp is an HTTP file transfer service that allows web developers to upload and download multi-gigabyte files and applications. FileUp transmits files of any format from a local hard disk to a server running Microsoft Internet Information Server (IIS) or to a separate file server that is networked to the Web server. [8]

See also

Related Research Articles

Microsoft Excel Spreadsheet, part of Microsoft Office

Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of the Microsoft Office suite of software.

Microsoft Access Database manager that is part of the Microsoft Office package

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.

Oracle Reports is a tool for developing reports against data stored in an Oracle database. Oracle Reports consists of Oracle Reports Developer and Oracle Application Server Reports Services.

Microsoft SQL Server Data Engine is a relational database management system developed by Microsoft. It is a scaled-down version of Microsoft SQL Server 7.0 or 2000 which is free for non-commercial use as well as certain limited commercial use. It was introduced at Microsoft TechEd in May 1999, and was included as part of Microsoft Office 2000 Developer Edition. Its successor, SQL Server Express was released in November 2005. Vendor support of MSDE ended on April 8, 2008.

Kexi a visual database applications creator and a free alternative to Microsoft Access

Kexi is a visual database applications creator tool by KDE, designed to fill the gap between spreadsheets and database solutions requiring more sophisticated development. Kexi can be used for designing and implementing databases, data inserting and processing, and performing queries. It is developed within the Calligra project but is released separately.

Microsoft Data Access Components framework

Microsoft Data Access Components is a framework of interrelated Microsoft technologies that allows programmers a uniform and comprehensive way of developing applications that can access almost any data store. Its components include: ActiveX Data Objects (ADO), OLE DB, and Open Database Connectivity (ODBC). There have been several deprecated components as well, such as the Microsoft Jet Database Engine, MSDASQL, and Remote Data Services (RDS). Some components have also become obsolete, such as the former Data Access Objects API and Remote Data Objects.

A pivot table is a table of statistics that summarizes the data of a more extensive table. This summary might include sums, averages, or other statistics, which the pivot table groups together in a meaningful way.

Microsoft SQL Server Analysis Services, SSAS, is an online analytical processing (OLAP) and data mining tool in Microsoft SQL Server. SSAS is used as a tool by organizations to analyze and make sense of information possibly spread out across multiple databases, or in disparate tables or files. Microsoft has included a number of services in SQL Server related to business intelligence and data warehousing. These services include Integration Services, Reporting Services and Analysis Services. Analysis Services includes a group of OLAP and data mining capabilities and comes in two flavors - Multidimensional and Tabular.

Microsoft Office 2007 version of Microsoft Office

Microsoft Office 2007 is a version of Microsoft Office, a family of office suites and productivity software for Windows, developed and published by Microsoft. It was released to manufacturing on November 3, 2006; it was subsequently made available to volume license customers on November 30, 2006, and later to retail on January 30, 2007, the same respective release dates of Windows Vista. It was preceded by Office 2003 and succeeded by Office 2010.

This is an overview of software support for the OpenDocument format, an open document file format for saving and exchanging editable office documents.

SQL Server Reporting Services (SSRS) is a server-based report generating software system from Microsoft. It is part of a suite of Microsoft SQL Server services, including SSAS and SSIS.

SQL Server Notification Services is a platform developed by Microsoft for the development and deployment of notification applications based on SQL Server Technology and the Microsoft .NET Framework. Notification Services offers a scalable server engine on which to run notification applications, with multi-server capability-providing flexibility and scalability for deploying applications.

Palo (OLAP database) OLAP database

Palo is a memory resident multidimensional database server and typically used as a business intelligence tool for controlling and budgeting purposes with spreadsheet software acting as the user interface. Beyond the multidimensional data concept, Palo enables multiple users to share one centralised data storage.

Microsoft SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications—which may run either on the same computer or on another computer across a network.

FarPoint Spread

This article refers to the last FarPoint Edition of the Spread Product line. Spread is now developed by GrapeCity, Inc. Since the acquisition, Spread for Biztalk Server has been removed from the product line and SpreadJS, a JavaScript version, has been added.

XLCubed

XLCubed is a business intelligence software and consulting services company. Established in 2001, XLCubed develops business intelligence software and provides business intelligence and performance management consulting services. The company is privately held and based out of the United Kingdom in the Thames Valley IT corridor.

BIDS Helper

BIDS Helper is a Visual Studio open source extension with multiple features that extend and enhance business intelligence development functionality in all editions of Microsoft's SQL Server 2005, 2008, 2008 R2 and 2012. BIDS Helper improves the development environment for integration, analysis and reporting services. BIDS Helper is hosted on GitHub.

References

  1. "SoftArtisans – Brookline, MA". The Inc.5000. Archived from the original on 2012-10-15. Retrieved 2019-09-16.
  2. "Deloitte & Touche North America Fast 500 2003" (PDF). DerekSpratt.com.
  3. "OfficeWriter now part of Microsoft stable". seattlepi.com. 2007-05-09. Retrieved 2019-09-16.
  4. Lachev, Teo (2008). Applied Microsoft SQL Server 2008 Reporting Services. Prologika Press. p. 9. ISBN   978-0-9766353-1-4.
  5. Robinson, Mark (2005). Microsoft SQL Server 2005 Reporting Services For Dummies. John Wiley & Sons. p. 387. ISBN   978-0-471-75884-6.
  6. Ganz, Carl (2007). Pro Crystal Enterprise / BusinessObjects XI Programming. Apress. p. 434. ISBN   978-1-4302-0277-6.
  7. Satya Jayanty (2005-09-30). "OfficeWriter for SQL Server Reporting Services". Archived from the original on 2010-12-31. Retrieved 2010-12-20.
  8. Newman, Paul (2002). The Joy of Dreamweaver MX: Recipes for Data-Driven Web Sites . Mcgraw-hill. ISBN   978-0-07-222464-1.