009 How to enable User defined fields

Add user defined fields to the ETL repository object tree with the required SQL for each repository database type.

Repository Database Updates
4.9 ★★★★★ Based on 16 reviews on Capterra See all reviews on Capterra →

The Update procedure

This update adds ten user defined fields to the repository object tree. Use it when the installed product expects those fields but the repository schema still belongs to an older version. Old repositories are loyal. Sometimes too loyal.

It applies to repositories used by Advanced ETL Processor and Visual Importer ETL.

Before you run the SQL

  1. Create a repository backup.
  2. Stop services and designers using the repository.
  3. Select only the SQL block for your repository database engine.
  4. Restart the application after the schema update.
Do not run every section unless you maintain every listed repository type. Choose Oracle, MS SQL Server, MySQL, PostgreSQL, or Interbase. Databases are picky about dialects, and they are not shy about saying so.

Run the matching SQL against the repository

For Oracle
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_01 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_02 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_03 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_04 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_05 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_06 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_07 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_08 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_09 Varchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_10 Varchar (255) NULL

For MS SQL Server
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_01 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_02 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_03 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_04 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_05 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_06 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_07 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_08 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_09 [nvarchar] (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_10 [nvarchar] (255) NULL

For MySQL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_01 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_02 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_03 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_04 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_05 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_06 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_07 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_08 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_09 nvarchar (255) NULL
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_10 nvarchar (255) NULL

For PostgreSQL
alter table objects_tree add user_field_01 varchar (255) null
alter table objects_tree add user_field_02 varchar (255) null
alter table objects_tree add user_field_03 varchar (255) null
alter table objects_tree add user_field_04 varchar (255) null
alter table objects_tree add user_field_05 varchar (255) null
alter table objects_tree add user_field_06 varchar (255) null
alter table objects_tree add user_field_07 varchar (255) null
alter table objects_tree add user_field_08 varchar (255) null
alter table objects_tree add user_field_09 varchar (255) null
alter table objects_tree add user_field_10 varchar (255) null

For Interbase
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_01 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_02 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_03 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_04 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_05 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_06 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_07 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_08 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_09 varchar (255)
ALTER TABLE OBJECTS_TREE ADD USER_FIELD_10 varchar (255)

After the repository update

Restart the product and check the screens that use user defined fields. If the fields are still missing, confirm that the SQL was run against the active repository and that the product is using that repository connection.

Note: If you are having problems upgrading our software please let us know and we will do our best to assist you.

By DB Software Laboratory Last updated