Business intelligence report provider

• US 9,875,467 B2
• Filed: 10/05/2012
• Issued: 01/23/2018
• Est. Priority Date: 10/05/2012
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Pedro de Matos, Lucio D'Orazio
• Primary Examiner(s): Zeender, Florian M
• Assistant Examiner(s): Racic, Milena
• Application Number:
  US13/645,640
• Publication Number:
  US 20140101010A1
• Time in Patent Office: 1,936 Days
• Field of Search: 709219, 705 34
• CPC Class Codes: G06F 16/2455 Query execution
• CPC Class Codes: G06Q 20/00 Payment architectures, schemes or protocols apparatus for performing or posting payment transactions G07F7/08, G07F19/00; electronic cash registers G07G1/12

Abstract

A system for providing a business intelligence report for a user. The system displays a list of available business intelligence reports. The system receives a request, from a business intelligence application, for at least one business intelligence report from the list of available business intelligence reports. The system provides configuration details to the business intelligence application. The configuration details determine a query. The business intelligence application performs the query on business data of a user database. The at least one business intelligence report is based upon the results of the query.

Claims

1. A non-transitory computer readable medium having instructions stored thereon that, when executed by a processor of a server, cause the processor to specify configuration details for providing a business intelligence report for a user, the processor:

in response to a business intelligence application connecting to the server through a firewall, providing by the server a list of available pre-defined business intelligence reports that are compatible with the business intelligence application and each comprise associated configuration details;

receiving a request by the server from the business intelligence application indicating a selection of a pre-defined business intelligence report from the list of available pre-defined business intelligence reports;

in response to the request, assembling by the server a Structured Query Language (SQL) code that defines a query configured to provide the pre-defined business intelligence report; and

providing the SQL code by the server to the business intelligence application, wherein the business intelligence application performs the query on business data associated with the business intelligence application and stored in a user database that is inaccessible to the server due to the firewall, wherein data retrieved by the query is used to generate and display the business intelligence report in accordance to corresponding configuration details.

2. The computer readable medium of claim 1, the processor further charging the user a fee each time the business intelligence report is provided or charging the user once for unlimited use of the business intelligence report.

3. The computer readable medium of claim 1, wherein the business data of the user database remains on a network inaccessible to a public entity or to a provider of the pre-defined business intelligence report.

4. The computer readable medium of claim 1, wherein the corresponding configuration details include a corresponding SQL code.

5. The computer readable medium of claim 1, the processor further receiving input parameters from the user via the business intelligence application, wherein the input parameters determine the corresponding configuration details.

6. The computer readable medium of claim 1, wherein the business intelligence application comprises Customer Relationship Management (CRM).

7. A method for specifying configuration details by a server for providing a business intelligence report for a user, the method comprising:

in response to a business intelligence application connecting to the server through a firewall, providing by the server a list of available pre-defined business intelligence reports that are compatible with the business intelligence application and each comprise associated configuration details;

receiving a request by the server from the business intelligence application indicating a selection of a pre-defined business intelligence report from the list of available pre-defined business intelligence reports;

in response to the request, assembling by the server a Structured Query Language (SQL) code that defines a query configured to provide the pre-defined business intelligence report; and

providing the SQL code by the server to the business intelligence application, wherein the business intelligence application performs the query on business data associated with the business intelligence application and stored in a user database that is inaccessible to the server due to the firewall, wherein data retrieved by the query is used to generate and display the business intelligence report in accordance to corresponding configuration details.

8. The method of claim 7, the specifying further comprising charging the user a fee each time the business intelligence report is provided or charging the user once for unlimited use of the business intelligence report.

9. The method of claim 7, wherein the business data of the user database remains on a network inaccessible to a public entity or to a provider of the pre-defined business intelligence report.

10. The method of claim 7, wherein the corresponding configuration details include a corresponding SQL code.

11. The method of claim 7, the specifying further comprising receiving input parameters from the user via the business intelligence application, wherein the input parameters determine the corresponding configuration details.

12. The method of claim 7, wherein the business intelligence application comprises Customer Relationship Management (CRM).

13. A system for specifying configuration details by a server for providing a business intelligence report for a user, the system comprising:

a processor of the server;

a memory coupled to the processor, the memory comprising;

a providing module that in response to a business intelligence application connecting to the server through a firewall, provides by the server a list of available pre-defined business intelligence reports that are compatible with the business intelligence application and each comprise associated configuration details;

a first receiving module that receives a request by the server from the business intelligence application indicating a selection of a pre-defined business intelligence report from the list of available pre-defined business intelligence reports, and in response to the request, the first receiving module assembling by the server a Structured Query Language (SQL) code that defines a query configured to provide the pre-defined business intelligence report; and

a first providing module that provides the SQL code by the server to the business intelligence application, wherein the business intelligence application performs the query on business data associated with the business intelligence application and stored in a user database, that is inaccessible to the server due to the firewall, wherein data retrieved by the query is used to generate and display the business intelligence report in accordance to corresponding configuration details.

14. The system of claim 13, the memory further comprising a charging module that charges the user a fee each time the business intelligence report is provided or charges the user once for unlimited use of the business intelligence report.

15. The system of claim 13, wherein the business data of the user database remains on a network inaccessible to a public entity or to a provider of the pre-defined business intelligence report.

16. The system of claim 13, wherein the corresponding configuration details include a corresponding SQL code.

17. The system of claim 13, the memory further comprising a second receiving module that receives input parameters from the user via the business intelligence application, wherein the input parameters determine the corresponding configuration details.

18. The system of claim 13, wherein the business intelligence application comprises Customer Relationship Management (CRM).