Document templates for schema-based data transfer into and out of a data-based application

摘要

Systems and methods are described for using templates associated with a document application to facilitate schema-based data transfers into and out of a database associated with a database application. Such templates may be made available to a user so that the user can easily export various data entities out of the database for display, editing, or report generation as well as to import new or edited data entities into the database. The templates may include fixed or user-customizable reports that are populated with data entities exported from the database and/or that present data and graphics derived from such data entities. The templates may also be created during an initial data transfer between a first document and the database and then saved for use in performing subsequent data transfers between other documents and the database.

主权项

1. A method comprising:
importing data into a database associated with a data-based application based on a template associated with a document application by:
transferring data entities entered into fields of the template by a user to a structured data document in accordance with a map associated with the template; andproviding the structured data document and connection information associated with the template to a database integration engine;wherein the connection information identifies a schema definition to be used by the database integration engine to extract the data entities from the structured data document, wherein the connection information identifies a data set within the database within which the extracted data entities are to be inserted by the database integration engine, wherein the connection information defines a link between the fields of the template and the data set within the database and wherein the connection information facilitates automated updates of the data set within the database based on and data currently stored in the fields of the template.