Using a non admin account

If you use SNDML with a non-admin ServiceNow account, then you must ensure that you have configured your ServiceNow Access Controls to grant read access to to all tables and columns that you intend to replicate. In addition, in order to generate table definitions, SNDML requires read access to these tables:

• sys_db_object
• sys_dictionary
• sys_glide_object

An alternative approach is to pull the table definitions from a separate sub-production instance. SNDML allows you to specify two ServiceNow instances. You can pull the schema definitions from a sub-production instance (using an account with admin role) while pulling the data from your production instance (using an account without admin role). This requires you to specify six parameters in the properties file as follows.

• servicenow.url - Production ServiceNow URL for data retrieval
• servicenow.username - Account without admin role
• servicenow.password
• datamart.schema.servicenow.url - Sub-production ServiceNow URL for schema retrieval
• datamart.schema.servicenow.username - Account with admin role
• datamart.schema.servicenow.password

A third approach is to manually create the tables in the target database. If SNDM encounters a table of the same name in the target database, it will match columns based on their name. Any columns which cannot be matched will not be loaded.