Urgent! Store data in servicenow without creating a new table

[ashwanikumar]

Hi Team,

Recently we have identified a new data source for the company table. We have an urgent need to have all this data in servicenow.

We already have OOTB company data and we have multiple processes integrated with the existing company records. 

We can not create or update existing data.

How can I manage new company data stream? Is there a way to store data without creating a new table for almost 6 months? Later we can migrate this data to OOTB company table.

[Ankur Bawiskar]

@ashwanikumar 

why to use new table to store company data?

Won't it be a tedious task later to maintain company data into 2 different tables

[ashwanikumar]

Hi Ankur,

thank you for the quick response.

We also not want to have 2 different sources but unfortunately we have very old setup in our customer instance and if we modify anything in current data records it would have huge impact.

We are working on improving customer data but this urgent requirement came for us to import new data sources in servicenow.

Is there any way to accomplish it without storing it in new table? (definitely we are going to migrate this data in the future.)

[Ankur Bawiskar]

@ashwanikumar 

you can use system property to store the values but it also cannot hold huge string values.

[ashwanikumar]

I have total 278 new company records, it would not be feasible to store it in system property.