SYSTEMS, METHODS AND COMPUTER PROGRAM PRODUCTS FOR INFORMATION INTEGRATION ACROSS DISPARATE INFORMATION SYSTEMS

• US 20140282910A1
• Filed: 03/14/2014
• Published: 09/18/2014
• Est. Priority Date: 03/14/2013
• Status: Active Grant

• Current Assignee: Ip Ot Sub Ulc
• Original Assignee: Open TEXT SA (Open Text Corporation)
• Inventors: Palmer, Jody Hupton, Lilko, Alexander, Molloy, Steve
• Granted Patent: US 10,182,054 B2
• Time in Patent Office: Days
• US Class Current: 726/4
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
• CPC Class Codes: G06F 16/9038 Presentation of query results
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation
• CPC Class Codes: G06F 21/10 Protecting distributed programs or content, e.g. vending or licensing of copyrighted material protection in video systems or pay television H04N7/16 ; Digital rights management [DRM]
• CPC Class Codes: G06F 21/6227 where protection concerns the structure of data, e.g. records, types, queries
• CPC Class Codes: H04L 63/10 for controlling access to devices or network resources

Abstract

An information integration system may include a set of integration services embodied on one or more server machines in a computing environment. The set of integration services may include connectors communicatively connected to disparate information systems. The connectors may be configured for integrating data stored in the disparate information systems utilizing a common model employed by the set of integration services. The common model may overlay, augment, integrate, or otherwise utilize a content management interoperability services data model and may include common property definitions and a common security model. The common security model may include permissions particularly defined for use by the set of integration services. These common property definitions and permissions may be uniquely defined and utilized by the information integration system.

Claims

1. A system, comprising:

a set of integration services embodied on one or more server machines in a computing environment, the set of integration services having a set of connectors communicatively connected to disparate information systems, the set of connectors configured for integrating data stored in the disparate information systems utilizing a common model employed by the set of integration services, the common model comprising a content management interoperability services (CMIS) data model, common property definitions, and a common security model comprising a set of permissions particularly defined for use by the set of integration services.

2. The system of claim 1, wherein the set of integration services further comprises a connector service provider interface configured for allowing a service provider to deploy and configure one or more extensible connectors used by the set of integration services to communicate with a particular backend system.

3. The system of claim 1, further comprising a data collector communicatively connected to the disparate information systems via the set of integration services.

4. The system of claim 1, further comprising a search system communicatively connected to the disparate information systems via the set of integration services.

5. The system of claim 4, wherein the set of integration services comprises a principal service configured for working with the search system in performing an inbound check, an authorization service configured for working with the search system in performing an outbound check, or a combination thereof.

6. The system of claim 1, further comprising:

a database communicatively connected to the set of integration services for storing encrypted user credentials.

7. A method for information integration, comprising:

deploying a set of integration services on one or more server machines in a computing environment, the set of integration services having a set of connectors communicatively connected to disparate information systems; and

integrating, via the set of connectors embodied on the one or more server machines, data stored in the disparate information systems utilizing a common model employed by the set of integration services, the common model comprising a content management interoperability services (CMIS) data model, common property definitions, and a common security model comprising a set of permissions particularly defined for use by the set of integration services.

8. The method according to claim 7, further comprising:

providing a service provider with a connector service provider interface configured for allowing the service provider to deploy and configure one or more extensible connectors used by the set of integration services to communicate with a particular backend system.

9. The method according to claim 7, further comprising:

configuring a data collector for obtaining data from the disparate information systems via the set of integration services.

10. The method according to claim 7, further comprising:

configuring a search system for searching the disparate information systems via the set of integration services.

11. The method according to claim 10, further comprising:

configuring a principal service for working with the search system in performing an inbound check.

12. The method according to claim 10, further comprising:

configuring an authorization service for working with the search system in performing an outbound check.

13. The method according to claim 7, further comprising:

storing encrypted user credentials in a database communicatively connected to the set of integration services.

14. A computer program product comprising at least one non-transitory computer readable medium storing instructions translatable by at least one process to perform:

deploying a set of integration services on one or more server machines in a computing environment, the set of integration services having a set of connectors communicatively connected to disparate information systems; and

integrating, via the set of connectors embodied on the one or more server machines, data stored in the disparate information systems utilizing a common model employed by the set of integration services, the common model comprising a content management interoperability services (CMIS) data model, common property definitions, and a common security model comprising a set of permissions particularly defined for use by the set of integration services.

15. The computer program product of claim 14, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

providing a connector service provider interface configured for allowing a service provider to deploy and configure one or more extensible connectors used by the set of integration services to communicate with a particular backend system.

16. The computer program product of claim 14, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

configuring a data collector for obtaining data from the disparate information systems via the set of integration services.

17. The computer program product of claim 14, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

configuring a search system for searching the disparate information systems via the set of integration services.

18. The computer program product of claim 17, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

configuring a principal service for working with the search system in performing an inbound check.

19. The computer program product of claim 17, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

configuring an authorization service for working with the search system in performing an outbound check.

20. The computer program product of claim 14, wherein the at least one non-transitory computer readable medium further stores instructions translatable by the at least one process to perform:

storing encrypted user credentials in a database communicatively connected to the set of integration services.

21. A data integration method for integrating data from data repositories, the data repositories using disparate data models for stored data, comprising:

using a set of integration services for integrating the data repositories and the data stored therein, the set of integration services defining a common model including common property definitions and a common security model, the set of integration services further defining data connectors to integrate data stored in the data repositories; and

using the common model to overlay a preexisting content management interoperability services model with the common property definitions and the common security model including a set of permissions defined for use by the set of integration services; and

using the data connectors to map the disparate data models of the data repositories such that the data stored in the data repositories become available to the set of integration services.

22. The method according to claim 21, wherein at least one of the data connectors is an extensible data connector, further comprising:

defining a data connector interface for use by a data repository provider to define and deploy an extensible data connector to map data stored in a data repository controlled by the data repository provider.

23. The method according to claim 21, further comprising:

using the set of integration services to search the data stored in the data repositories in a unified manner despite differences in the disparate data models.

24. The method according to claim 21, further comprising:

configuring at least one of the connectors to integrate related data within a first one of the disparate information systems and a second one of the disparate information systems, including;

defining a common key in the common data model; and

integrating first data stored in the first one of the disparate information systems and second data stored in the second one of the disparate information systems by utilizing the common key to co-reference the first data and the second data.

25. The method according to claim 21, further comprising:

configuring at least one of the connectors to;

support a common set of permissions in the common security model to access information in the disparate information systems; and

generate a mapping of the common set of permissions to a set of permissions defined for a subject disparate information system; and

utilizing, by at least one of the set of integration services, the mapping to access information in the subject disparate information system.