Exporting all Data From X3

SUGGESTED

Hi im wondering if anyone can help, is there a way of extracting all financial data from the X3 system to keep for reference e.g csv file, we are moving awaty from x3 and i need to get the data for my finance team

Parents
  • 0
    SUGGESTED

    Hi ,
    We're really sorry to see you moving away from Sage X3.

    If I may ask what led to it ? You don't have to answer if you don't want to, I'm just curious Slight smile

    I think you need to start by defining "all financial data". If I were to take it from the stand point of a new customer coming to X3 and preparing data migration, we usually define the list of documents we need and ask the initial system to export it for us. You'll definitely need some equivalent sooner or later unless the future system get some kind of transformation gateway that can automate some of it for you.

    I'm not sure my boss will be happy to see me helping you leaving Sage X3, but:

    - 90% of X3 data model can be found on the online help:

    https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/MCD/INDEX.htm

    Although they are from the V6 days (2010), the main data model hasn't evolved drastically.

    - You can use the native export models that are designed per X3 objects (documents), although it can be a little bit long in terms of processing time if you have large data volumes.

    Like Mike mentioned, you can also export data from SQL Server to Excel (if not using Oracle), but it is a bit technical as you need to register the OLEDB drivers for your version of Excel, and filter all tables for a given database schema (X3 folder).

    In any case, I would advise you to keep a database back up and a folder export just in case.

Reply
  • 0
    SUGGESTED

    Hi ,
    We're really sorry to see you moving away from Sage X3.

    If I may ask what led to it ? You don't have to answer if you don't want to, I'm just curious Slight smile

    I think you need to start by defining "all financial data". If I were to take it from the stand point of a new customer coming to X3 and preparing data migration, we usually define the list of documents we need and ask the initial system to export it for us. You'll definitely need some equivalent sooner or later unless the future system get some kind of transformation gateway that can automate some of it for you.

    I'm not sure my boss will be happy to see me helping you leaving Sage X3, but:

    - 90% of X3 data model can be found on the online help:

    https://online-help.sageerpx3.com/erp/12/wp-static-content/static-pages/en_US/MCD/INDEX.htm

    Although they are from the V6 days (2010), the main data model hasn't evolved drastically.

    - You can use the native export models that are designed per X3 objects (documents), although it can be a little bit long in terms of processing time if you have large data volumes.

    Like Mike mentioned, you can also export data from SQL Server to Excel (if not using Oracle), but it is a bit technical as you need to register the OLEDB drivers for your version of Excel, and filter all tables for a given database schema (X3 folder).

    In any case, I would advise you to keep a database back up and a folder export just in case.

Children
No Data