Connection tool for connecting analytical applications to electronic document sources

• US 20020143644A1
• Filed: 04/03/2001
• Published: 10/03/2002
• Est. Priority Date: 04/03/2001
• Status: Abandoned Application

• Current Assignee: Sapmarkets Incorporated
• Original Assignee: SAP AG (SAP SE)
• Inventors: Chew, Kok Thim, Tosun, Cafer
• Application Number:
  US09/825,004
• Publication Number:
  US 20020143644A1
• Time in Patent Office: Days
• US Class Current: 705/26
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06Q 30/0601 Electronic shopping [e-shopping]

Abstract

A connection tool to extract information from an electronic document source, for instance an XML source, such as an electronic marketplace, and convert it to a compatible format before providing it to an analytical application, such as a data warehouse system.

Claims

1. A connection tool, said connection tool being capable of extracting data from documents on an electronic marketplace and converting a format of said data to be compatible with a data warehouse, comprising:

a server, said server accepting said document from said electronic marketplace and managing extraction of information from said documents based upon document subscriptions;

a listener interface, said listener interface forming an interface between said server and an output of said connection tool;

at least one extraction schema, said at least one extraction schema extracting said information and formatting said information so as to create said output.

2. A connection tool according to claim 1, wherein said output comprises information extracted from a predetermined document type and is sent to subscribers of said predetermined document type.

3. A connection tool according to claim 1, wherein said at least one extraction schema comprises a purchase order listener.

4. A connection tool according to claim 1, wherein said at least one extraction schema comprises a purchase order acknowledgement listener.

5. A connection tool according to claim 1, wherein said connection tool comprises a plurality of extraction schemas, said plurality of extraction schemas comprising a purchase order listener, a purchase order acknowledgement listener, a sales order listener, a sales order acknowledgement listener and an invoice listener.

6. A connection tool according to claim 1, wherein said documents are XML documents.

7. A connection tool according to claim 1, wherein said listener interface can be configured via an XML property file.

8. An electronic marketplace for facilitating electronic commerce between a plurality of users through the exchange and processing of electronic documents comprising:

a plurality of business services, said plurality of business services comprising applications facilitating electronic commerce;

a router, said router routing said electronic documents within said electronic marketplace;

a connection tool, said connection tool being capable of extracting data from said documents and converting a format of said data to be compatible with a data warehouse.

9. An electronic marketplace as in claim 10 wherein said connection tool comprises:

a server, said server managing extraction of information from said electronic documents;

a listener interface, said listener interface forming an interface between said server and an output of said connection tool;

at least one extraction schema, said at least one extraction schema extracting said information and formatting said information to create said output.

10. An electronic marketplace as in claim 8, further comprising a data warehouse.

11. An electronic marketplace as in claim 8, wherein said data warehouse is remotely located from said electronic marketplace.

12. An electronic marketplace as in claim 8, wherein said router copies documents passing through it and provides said copies to said connection tool.

13. An electronic marketplace as in claim 12, wherein said router provides said copies to said connection tool regardless of an intended destination of said documents.

14. An electronic marketplace as in claim 8, wherein said users send at least two copies of said documents to said electronic marketplace, a first copy indicating a destination within said business services and said second copy indicating a destination of said connection tool, said router routing documents according to said indicated destinations.

15. An electronic marketplace as in claim 8, wherein documents arriving at said electronic marketplace from said users are in a first format, said first format being compatible with said data warehouse, said connection tool converts said documents to a second format, said second format being compatible with said business services, prior to sending said documents to said business services and converts second format documents exiting said business services back to said first format prior to sending said second format documents to said router.