Determine relationships between tables in ServiceNow

[sbosch]

We are using Microsoft SQL Server to pull data from our ServiceNow instance in order to

incorporate it into a BI tool. We want to combine various tables via the ETL tool in Microsoft SQL Server(SSIS).

In order to do this, we need to know how the tables in ServiceNow are related.

I can see which tables reference one another using the Schema Map

and the Tables and Columns module. However, I would like to know how the tables are

related — whether the relationship between two given tables is many to many, one to many, one to one,

or zero to one, for instance.   We need to know this in order to determine hot to join the tables.

Any information you can provide would be appreciated.

[manikorada]

Stephen,

There is no direct API which will give you that.

For one to one/ one to many relationship , this is connected using a reference table on one table.

All many to many table are stored in sys_m2m table, may be you can get the required information for this relationship from this table.

But I would suggest if you know the table you need to get that, have a temp table to hold this information.

[morgang]

You might watch table names for mtom, which indicates many to many.