This discussion is archived
6 Replies Latest reply: Apr 17, 2013 2:22 AM by Alan Lawlor RSS

Oracle RMS Test Data

906727 Newbie
Currently Being Moderated
Hi,

Is there any sample data available for Retail Merchandising System (RMS)?

if there is any sample data, please provide the Details regarding to it.

Appreciate the help in advance.

Regards,
Prasanthi
  • 1. Re: Oracle RMS Test Data
    AnveshReddy Newbie
    Currently Being Moderated
    Hi Prasanthi,

    You asked about Sample data, what actually do you mean by it?

    Whether you need any demo data to work on or something else ?

    Regards,
    Anvesh
  • 2. Re: Oracle RMS Test Data
    906727 Newbie
    Currently Being Moderated
    Hi Anvesh,
    your understanding is correct,

    i need demo data for RMS from where i can populate the data to RA (Retail Analytics) for Analytics purpose.
    if u can provide demo data either for RMS or for RA it would be helpful.

    Thanks in advance for ur help.

    Regards,
    Prasanthi
  • 3. Re: Oracle RMS Test Data
    AnveshReddy Newbie
    Currently Being Moderated
    HI Prashanthi,

    The demo data is inserted while you create the DB schema for the applications. While creating the DB schema itself it will ask you whether you want demo data or not !

    So may may be your schema is created without the Demo Data.

    The only thing you can do now is insert the data from backend (i.e into the database tables directly). Obviously its a big task.

    But the good thing here is there will be sql scripts in the source file itself. You can run them so that the data is inserted into the database.

    Regards,
    Anvesh
  • 4. Re: Oracle RMS Test Data
    906727 Newbie
    Currently Being Moderated
    Hi Anvesh,

    I really agree with your idea, but unfortunately we don't have option of Demo data insertion while creating schema for Retail Analytics.
    and there are no scripts which i could found to populate the demo data for RA.

    if you have any information on this pls help me providing the details of it

    Thanks

    Prasanthi
  • 5. Re: Oracle RMS Test Data
    AnveshReddy Newbie
    Currently Being Moderated
    Hi Prashanthi,

    In that case, create a new DB with RMS schema and map it to RA !

    Regards,
    Anvesh
  • 6. Re: Oracle RMS Test Data
    Alan Lawlor Explorer
    Currently Being Moderated
    There is demo data for RMS, which can be inserted during install. You can also insert it later by manually running the demo data SQL*Plus scripts.

    It might be in a different location in RMS13, but in RMS12, you can find the scripts which insert demo/seed data in the staging folder in /dbserverunix/data.

    From there you can run rmsdemodata.sql.

    However, there is only data for master data (options, udas, items, suppliers, etc), none for transactional data.

    You would need to create your own.

    One method would be to create your own transactional data in a text file run the migration scripts (in the staging folder under /dbserverunix/dataconversion

    I do not know Retail Analytics so I am unsure how you would trigger this generated data to import into the Analytics module

    Hope this helps

    Edited by: Alan Lawlor on 17-Apr-2013 10:21

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points