Question on JDBC data source

snow57
Tera Contributor

‎12-05-2023 11:27 AM

Hi, i have a SQL data source , added a new field to the instance to get the data from the SQL DB(configuration is completed from the SQL side). the values for the new field are there in the SQL DB but while importing this the new field is not displaying in the ServiceNow Instance(displaying as blank in the import logs) ? what would be the reason for this? Did anyone faced like this ?

 

0 Helpfuls
  • 245 Views
6 REPLIES 6

-O-
Kilo Patron
Kilo Patron

‎12-05-2023 04:31 PM

Have you specified a custom query or just the table name?

0 Helpfuls

snow57
Tera Contributor
In response to -O-

‎12-06-2023 05:45 AM

Hi, 

Just the table name

0 Helpfuls

-O-
Kilo Patron
Kilo Patron
In response to snow57

‎12-06-2023 07:43 AM - edited ‎12-06-2023 12:28 PM

I would try to turn it into a "query based" data source.

It might throw some error and shed some light onto what might be going wrong.

0 Helpfuls

snow57
Tera Contributor
In response to -O-

‎12-17-2023 09:03 PM

Hi, 

Sure , Thanks.

0 Helpfuls