My past BI experience has been with NOETIX/INFORMATICA in a mixed Oracle ERP source with an MS SQL based warehouse environment. So, I am familiar ETL concepts, but I am a complete newbie to Oracle ODI.
I want to move an extract of the FND_USER from its source to my target environment. We are working in an 11g development environment. We call our development environment EDEV and I connect using SQL Developer with the APPS user. Our convention is to create user tables under the TXX user. So, our target tables would be named TXX.TXX_TABLE_NAME.
I want to move three columns (USER_NAME, END_DATE, EMAIL_ADDRESS) from APPLSYS.FND_USER into my target table TXX.TXX_FND_USER_EXTRACT. If I were doing this in SQL Developer or via command line, the insert query might look something like:
INSERT INTO TXX.TXX_FND_USER_EXTRACT (USER_NAME, END_DATE, EMAIL_ADDRESS)
SELECT USER_NAME, END_DATE, EMAIL_ADDRESS FROM APPLSYS.FND_USER
However, I want to do this using an ETL via ODI, so it can feed a larger dataset. Once I get the data transfer part worked out, I think I understand the scheduling part. So, let me start at the interface and work backward.
INTERFACE: This is where I will define the Source and Target tables, as defined by Models.
MODELS: We already have an FND_USER source model that I can use. So, this is the crux of my question. How do I set up a “target” model for the TXX.TXX_FND_USER_EXTRACT in my EDEV environment?
When I try to create the model, it asks for the Logical Schema. There is no logical schema for the EDEV environment.
It is my understanding that I need to create a Logical Schema under Topology, but I am not sure how to do that.
So, how do I create the Logical Schema and does this “point” ODI to my EDEV environment where my target resides?
Any input would be appreciated.