Soultions > Solutions by Application : SharePoint

SharePoint

Do you need to integrate enterprise system data (such as ERP and other enterprise systems) with MS Office and MS SharePoint? If so, Microsoft Office SharePoint Server (MOSS) provides an easy way to create Web portals with integrated document management services and search capabilities.

This increasingly popular solution can aggregate information from several different sources into one convenient place.

Datawatch can add significant value to SharePoint by helping you easily transform information from multiple systems into MS Office formats (including Open XML spreadsheets, for access or use within SharePoint) as well as populate SharePoint KPIs.

Contact us today to learn more about the value Datawatch can add to your SharePoint Portal Server implementation. 

Problem Departmental Solution Enterprise Solution
SharePoint is being used to provide the portal for analytics for the enterprise,  however, the required data comes from a wide variety of internal systems, as well as from external entities, where there are no integration possibilities. To gain full acceptance, it needs to ensure a single view of the truth

Users extract data from reports generated on any system without access to the underlying data layer with Monarch. 

Monarch exports Open XML spreadsheets that are web-enabled in Excel Services directly to SharePoint (these spreadsheets can also be used as a source for SharePoint KPI Web Parts)

Monarch Data Pump Pro can automatically create or replace Excel, PDF and many other formats in SharePoint on a scheduled or event- driven basis - it can also export Open XML spreadsheets for Excel Web Access and SharePoint KPI Web Parts

Monarch Data Pump Pro can populate SQL Server 2005, integrating closely with SSIS to load data into SQL Analysis Services for use with SharePoint

 
The need to integrate the vast amounts of reports and other unstructured data sources generated by multiple systems throughout the enterprise with SharePoint to provide more control and greater user leverage of company documents and information,

Users extract data from reports generated on any system without access to the underlying data layer with Monarch
Monarch supports exporting, importing and retention of metadata directly to SharePoint

Monarch can republish reports in a compressed PDF file with bookmarks for easy navigation or to extract, filter, transform and analyze the data for export in Excel (xls), Open XML spreadsheet format (xlsx) or PDF

 

Monarch Data Pump can automatically extract and publish a wide variety of files directly to SharePoint on an event-driven or scheduled basis

Monarch Data Pump can be integrated with SSIS to populate SQL Server 2005, or SQL 2005 Analysis Services to provide data to SharePoint from a database perspective, as well as a file-based perspective

 
Integrate enterprise system data (such as ERP and other enterprise systems) with MS Office and MS SharePoint Monarch transforms existing enterprise system report output into live, actionable, customized data in Excel, with many powerful Excel-specific capabilitiesMonarch Pro can also mine data from PDF files and combine report-based information with other data sources that can be delivered as Excel or Access files, and directly exported to existing SharePoint repositories Monarch Data Pump provides completely automated, programming-free report and data mining with a wide variety of export options, including automatic exporting to SharePoint repositories, with macro-driven file naming and more
Create Excel 2007 (Open XML format) files containing customized enterprise data Monarch can export desired data views directly to Open XML (xlsx) format, including directly to SharePoint Monarch Data Pump offers the ability to mine reports and other data sources and export customized data views to Open XML (xlsx) format, on a completely automated basis
Automatically create SharePoint KPI’s without programming Not applicable Monarch Data Pump automatically creates named ranges containing desired aggregated data mined from reports and other data sources without programming; ready for use to populate SharePoint KPI’s on a scheduled basis

Contact Us

North America

Europe, Mideast & Africa

Central & South America

PacRim