What is the best database for exporting archived ServiceNow data?

[shayanfayaz]

Hello!
I have a question, What is the best database for exporting archived ServiceNow data? Considering factors like scalability, integration, cost, and performance, which solution works best for long-term storage and easy retrieval? If you've implemented an external database, how did you use it for maximum efficiency?And how its done?

[Daniel Madsen]

Hello!

Are you talking about a specific subset of data, or is it a 1-to-1 copy of the tables in ServiceNow? ServiceNow uses MariaDB as its database, so it would be a good match as an external database. Please be aware that ServiceNow is changing their database to RaptorDB, which is a fork of PostgreSQL, and may be a better option in the future.

[shayanfayaz]

Thanks for your response! I'm looking into both approaches—maintaining a 1-to-1 copy of tables vs. archiving only specific subsets of data. Given that ServiceNow is moving to RaptorDB, how do you think this transition will impact external database choices? Would PostgreSQL/RaptorDB be a better long-term option, or would MariaDB still be a viable solution for archival?

[muslimaltaf]

Thanks for your response!

I'm looking into both approaches—maintaining a 1-to-1 copy of tables vs. archiving only specific subsets of data. Given that ServiceNow is moving to RaptorDB, how do you think this transition will impact external database choices? Would PostgreSQL/RaptorDB be a better long-term option, or would MariaDB still be a viable solution for archival ?

[Daniel Madsen]

I believe it will have an impact, as not all data types are compatible between the two database systems. ServiceNow will handle the data migration when changing the database, but any external systems will be affected and will need to be converted as well. Unless you have an abstraction layer between ServiceNow and your external backup solution to manage the translation, you're likely to encounter errors. In that case, I recommend matching the database technology used by ServiceNow.

To find out which database technology you are currently using, navigate to /xmlstats.do and search for the db.rdbms and db.driver_name properties. These will indicate the type of database you are currently using.