Main Page: Difference between revisions

From Grooper Wiki
VisualWikitext
No edit summary
No edit summary
Line 22: Line 22:
|
|
<blockquote style="font-size:14pt">
<blockquote style="font-size:14pt">
'''[[Database Export]]'''
'''[[CMIS Lookup]]'''
</blockquote>
</blockquote>


[[File:Database_export_002.png|thumb]]
[[File:cmis_lookup_002.png|right|link=CMIS Lookup]]


Database Export is one of the main ways to '''[[Five Phases of Grooper|Deliver]]''' data '''[[Five Phases of Grooper|Collected]]''' in Grooper.
<blockquote style="font-size:14pt">
 
Performing data lookups on '''[https://en.wikipedia.org/wiki/Content_Management_Interoperability_Services CMIS]''' sources like '''[https://en.wikipedia.org/wiki/SharePoint SharePoint]''' can be extremely powerful in your data integration endeavors.</blockquote>
A completed '''[[Content Model]]''' and accompanying '''[[Batch]]''' for what will be built can be found '''[[Media:Database Export.zip|here]]'''. It is not required to download to understand this article, but can be helpful because it can be used to follow along with the content of this article. ''This file was exported from and meant for use in Grooper 2.9''
 
The most important goal of '''Grooper''' is to deliver accurate data to line of business systems that allow the information to be integrated into impactful business decisioning. [https://en.wikipedia.org/wiki/Table_(information) Tables] in [https://en.wikipedia.org/wiki/Database databases] remain, to this day, one of the main vessels by which this information is stored. '''Grooper's''' '''Database Export''' activity is the mechanism by which this delivery is performed. '''Database Export''' uses a configured '''[[Data Connection]]''' to establish a link to ('''[https://en.wikipedia.org/wiki/Microsoft_SQL_Server Microsoft SQL Server]''' or '''[https://en.wikipedia.org/wiki/Open_Database_Connectivity ODBC-compliant]''') tables in a database and intelligently populate said tables.</p>
 
Two ''key distinctions'' about '''Grooper's''' '''Database Export''' activity are its ability to take full advantage of its sophisticated hierarchical data modeling to flatten complex/inherited data structures, and the ease of delivery to multiple tables at once.


For more information on Database Export, visit the full wiki artcile [[Database Export|here]].
'''Grooper''' uses the CMIS protocol to connect to a variety of '''[https://en.wikipedia.org/wiki/Content_management_system Content Management Systems.]''' This connection can be used to integrate data in powerful ways by allowing the collection of one (or sometimes many) fields of information within a model in '''Grooper''' (let's call it Field A), then leveraging that extracted data point against the column of like information in the Content Management system (called Column A) to then pass back other desired fields from other columns in the same row of information.
|
|
[[Database Lookup]]s changed in version 2.80.  Prior to Version 2.80, database lookups were performed on individual Data Fields in a Data Model, using simple field mappings.
Grooper re-envisioned how to connect to CMIS sources and other storage platforms in version 2.72.  Prior to this version, Grooper users connected to various storage systems through a variety of Import and Export Providers.  In version 2.72, we created a unified framework to connect to data sources with our [[CMIS+]] Architecture!


Now, lookups are configured on a Data Model, Data Section or Data Table’s properties, using SQL queries. Other improvements include:
This new architecture allows for easier integration of CMIS systems with Grooper, as well as exposing non-CMIS sources, such as the Windows file system and Microsoft Outlook inboxes, as if they were CMIS sources. This provided a more standardized import/export workflow across a variety of storage systems, increased ability to map document metadata on import and export, better ability to search, query and filter document repositories, and faster integration of new content management systems, such as the new [[Box (CMIS Binding)|Box.com]] integration.
*Multiple database lookups using multiple SQL queries can be written on the Data Model.
*Lookups can reference any number of database columns and Grooper fields.
*During review, Grooper now provides a UI dialogue box when multiple matches are returned to choose the correct value.
 
Visit the [[Database Lookup]] article for more information.
|}
|}


Line 91: Line 81:


|
|
[[File:Olers-insurance-document-capture-service-case-study-grooper.jpg|thumb]]
[[File:American-airlines-credit-union-financial-services-document-data-capture-integration-grooper.jpg|400px|right|link=https://www.bisok.com/case-studies/electronic-data-discovery-case-study/]]


<blockquote style="font-size:14pt">
<blockquote style="font-size:14pt">
'''Empowering Faster and Safer Services for Thousands of Public Servants'''
'''They’re Saving Over 5,000 Hours Every Year in Data Discovery and Processing'''
</blockquote>
</blockquote>




With over 100 years of public servant records on disks or paper files, the Oklahoma Law Enforcement Retirement System needed a new modern system to protect private information and streamline daily workflows.
American Airlines Credit Union has transformed their data workflows, quickly saving thousands of hours in electronic data discovery , resulting in much greater efficiency and improved member services.
 
In 1947, Oklahoma Senate Bill 125 created a Death, Disability and Retirement
Fund for Department of Public Safety members. In 1980, a new bill
established the Oklahoma Law Enforcement Retirement System (OLERS)
which continued the previous plan and expanded upon it to include
members of other law enforcement agencies.


Currently, OLERS provides retirement funds to 11 different statewide law
Discover how they:
enforcement agencies.


Key Outcomes:
* Quickly found 40,000 specific files among one billion
*Saving Hundreds of Hours Annually with Modern Document Management
* Easily integrated with data silos and content management systems when no other solution would
*Monthly Capture Service Provides Additional Time Savings
* Have cut their mortgage processing time in half (and they process mortgages for 47 branch offices!)
*Many Layers of Personal InformationProtection
* Learn from the document and electronic data discovery experts at BIS!
*Redaction of At-Risk Data


[https://www.bisok.com/case-studies/empowering-faster-and-safer-services-for-thousands-of-public-servants/ You can access the full case study clicking this link].
[https://www.bisok.com/case-studies/electronic-data-discovery-case-study/ You can access the full case study clicking this link].
|}
|}


Revision as of 14:27, 13 July 2020

Getting Started

Grooper is a software application that helps organizations innovate workflows by integrating difficult data.

Grooper empowers rapid innovation for organizations processing and integrating large quantities of difficult data. Created by a team of courageous developers frustrated by limitations in existing solutions, Grooper is an intelligent document and digital data integration platform. Grooper combines patented and sophisticated image processing, capture technology, machine learning, and natural language processing. Grooper – intelligent document processing; limitless, template-free data integration.

Getting Started
Install and Setup
2.80 Reference Documentation


Featured Articles Did you know?

CMIS Lookup

Performing data lookups on CMIS sources like SharePoint can be extremely powerful in your data integration endeavors.

Grooper uses the CMIS protocol to connect to a variety of Content Management Systems. This connection can be used to integrate data in powerful ways by allowing the collection of one (or sometimes many) fields of information within a model in Grooper (let's call it Field A), then leveraging that extracted data point against the column of like information in the Content Management system (called Column A) to then pass back other desired fields from other columns in the same row of information.

Grooper re-envisioned how to connect to CMIS sources and other storage platforms in version 2.72. Prior to this version, Grooper users connected to various storage systems through a variety of Import and Export Providers. In version 2.72, we created a unified framework to connect to data sources with our CMIS+ Architecture!

This new architecture allows for easier integration of CMIS systems with Grooper, as well as exposing non-CMIS sources, such as the Windows file system and Microsoft Outlook inboxes, as if they were CMIS sources. This provided a more standardized import/export workflow across a variety of storage systems, increased ability to map document metadata on import and export, better ability to search, query and filter document repositories, and faster integration of new content management systems, such as the new Box.com integration.

New in 2.9 Featured Use Case

Welcome to Grooper 2.9!
Below you will find helpful links to all the articles about the new/changed functionality in this version of Grooper.
Compile Stats Microsoft Office Integration Document Viewer Separation and Separation Review
Data Review Confidence Multiplier Data Element Overrides Database Export
CMIS Lookup Content Type Filter Output Extractor Key Box (CMIS Binding)
LINQ to Grooper Objects

They’re Saving Over 5,000 Hours Every Year in Data Discovery and Processing


American Airlines Credit Union has transformed their data workflows, quickly saving thousands of hours in electronic data discovery , resulting in much greater efficiency and improved member services.

Discover how they:

  • Quickly found 40,000 specific files among one billion
  • Easily integrated with data silos and content management systems when no other solution would
  • Have cut their mortgage processing time in half (and they process mortgages for 47 branch offices!)
  • Learn from the document and electronic data discovery experts at BIS!

You can access the full case study clicking this link.


Other Resources


Retrieved from "https://wiki.grooper.com/index.php?title=Main_Page&oldid=3920"