Creating and populating reporting tables

You must import following views in design time database and runtime database. You must use your own tools for this step. The SQL Generator does not generate the SQL for you.

  • Execute the views on Campaign database. Interact installer lays down database scripts under the Interact installation location which contains these views. Scripts are available at <INTERACT_HOME>/reports/ddl/<dbtype>/InteractDT.sql.
  • Execute the views on Interact Runtime database. Interact installer lay down database script under the Interact installation location which contains these views. Scripts are available at <INTERACT_HOME>/reports/ddl/<dbtype>/InteractRT.sql.
    Note: In case if you face any issue while running script through CLI, then you must use IBM Data Studio Client or before running the script you may require to remove leading or trailing spaces from the SQL statement given in the file and close all statements with semicolon.