2 Replies Latest reply: Jan 6, 2012 2:31 PM by Alex Kotopoulis RSS

    Store data from source to destination using data services

    909432
      Two data services have been created in ODSI. One for source and other for destination. Now, I need to get the data from source and store the data to the destination. Would need your help on how to implement this functionality.

      Thanks.
        • 1. Re: Store data from source to destination using data services
          Mikereiche-Oracle
          I need to get the data from source and store the data to the destination
          Without knowing any more than that - you should be using ODI, not ODSI.
          ------------------------------------------------------------------------------------

          There are two parts to copying data - reading the data from the source - which is well described in the ODSI documentation; and then creating the data in the destination - which is also well described in the ODSI documentation. All you need to do is put the two together. If you create a logical DS for the source containing a read function with same schema as the input to the create function for the destination - you'll be able to pass it directly.

          Good luck,

          - Mike
          • 2. Re: Store data from source to destination using data services
            Alex Kotopoulis
            Hi,

            this kind of stateful behavior can best be done in ODSI using the XQSE scripting language (Think of it as the PL/SQL of XQuery). THis is documented at:

            http://docs.oracle.com/cd/E13162_01/odsi/docs10gr3/xquery/xqse.html
            http://docs.oracle.com/cd/E13162_01/odsi/docs10gr3/dsp32wiki/How%20To%20Develop%20Good%20XQSEs.html
            At the end of the second link there is a sample to move data using ODSI.

            As Mike already said, data movement of large amounts of data is best done with specialized ETL tools such as ODI. ODSI is not meant to be an ETL tool.

            Regards,
            Alex