Database part

You may either install the product into an existing database schema or create a new schema. In the latter case just run sql script from a shell like SQL*Plus or SQLcl under administrative (e.g. SYS) account (change the username and the password in the source file if necessary):

start CreateRDUser.sql

If you would prefer to use an existing schema make sure that it has enough tablespace quota and the following permissions:

CREATE SESSION, CREATE TABLE, CREATE VIEW, CREATE SEQUENCE, CREATE PROCEDURE, CREATE ANY SYNONYM, CREATE TYPE

Database objects include 5 tables with indexes and sequences:

• customxml_attribute
• customxml_node
• explorantum_product
• report_component
• report_template

and 4 stored packages:

• as_xlsx
• Explorantum_Crypto_Pkg
• Report_Designer_Pkg
• Report_Designer_License_Pkg

All these database objects must be installed into Parsing Schemas of each Apex application creating reports with Report Designer. To do that:

• log in to shell like SQL*Plus or SQLcl under account where database objects will be placed (e.g. REPORT_DESIGNER)
• run command:

  start DDLReportDesigner.sql

Repeat these steps for each (parsing) schema (if necessary) and proceed to installation of APEX part.