Table naming rules

Starting with version 12.0.11C (2020-12) the names of custom tables in the Staging database must differ from table names in the Integration database.

Staging tables with names that are duplicated in Integration are hidden from the navigation. The load queries of such tables have been moved and are now under the Integration tables of the same names.

Follow this procedure to replace the hidden staging tables and retrieve their data.

  1. Create new Staging tables with the required schema. The hidden tables are listed in the application logs.
    You can use load queries against the hidden tables to create the schema of the new tables. The tables that are hidden from the navigation remain visible in the load query object browser.
  2. Use load queries against the hidden tables to retrieve their data.
  3. Copy and paste the SQL statements of the hidden tables' load queries, from the Integration tables to the new Staging tables.
  4. Delete the copied load queries from the Integration tables.
  5. Update any SQL scripts that reference the original Staging tables.
  6. Update any Non-SQL scripts that reference the original Staging tables and their load queries.
  7. Update workflows, data flows, and Application Engine processes that reference the load queries of the original Staging tables.
  8. Delete the hidden Staging tables.
    Use Microsoft SQL Server Management Studio to delete the tables.