System and method for data analytics with an analytic applications environment

A method for providing an analytic applications environment, comprising:

• providing access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants, wherein the data warehouse is associated with an analytic applications schema;
• associating each tenant of the plurality of tenants with a customer tenancy, and a customer schema for use by the tenant in populating a data warehouse instance;
• and
• populating an instance of the data warehouse with data received from an enterprise software application or data environment, wherein data associated with a particular tenant of the analytic applications environment is provisioned in the data warehouse instance associated with, and accessible to, the particular tenant, in accordance with the analytic applications schema and the customer schema associated with the particular tenant.

A non-transitory computer readable storage medium having instructions thereon, which when read and executed by a computer including one or more processors cause the computer to perform a method comprising:

• providing access by an analytic applications environment to a data warehouse for storage of data by a plurality of tenants, wherein the data warehouse is associated with an analytic applications schema;
• associating each tenant of the plurality of tenants with a customer tenancy, and a customer schema for use by the tenant in populating a data warehouse instance;
• and
• populating an instance of the data warehouse with data received from an enterprise software application or data environment, wherein data associated with a particular tenant of the analytic applications environment is provisioned in the data warehouse instance associated with, and accessible to, the particular tenant, in accordance with the analytic applications schema and the customer schema associated with the particular tenant.

A system for use of schemas with an analytic applications environment, comprising:

• a computer including one or more processors, that provides access by an analytic applications environment to a data warehouse for storage of data;
• wherein each tenant of a plurality of tenants is associated with:
• a tenancy provided within the data warehouse, and
• a schema for use by the tenant, that is provided within the analytic applications environment;
• wherein each tenant is provided with access to an analytic applications schema, that is accessible to the plurality of tenants and that is updated by the analytic applications environment;
• and
• wherein a database table associated with a particular tenant can be used in accordance with the particular tenant's schema, and with the analytic applications schema, to populate an instance of the data warehouse associated with the particular tenant.

A method for use of schemas with an analytic applications environment, comprising:

• providing access by an analytic applications environment to a data warehouse for storage of data, wherein each tenant of a plurality of tenants is associated with:
• a tenancy provided within the data warehouse, and
• a schema for use by the tenant, that is provided within the analytic applications environment;
• wherein each tenant is provided with access to an analytic applications schema, that is accessible to the plurality of tenants and that is updated by the analytic applications environment;
• and
• wherein a database table associated with a particular tenant can be used in accordance with the particular tenant's schema, and with the analytic applications schema, to populate an instance of the data warehouse associated with the particular tenant.