Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using XML File as a Data Server

geeo73Sep 17 2008 — edited Sep 23 2008
OK - here's my scenario:

- Have an XML file that I am holding parameters (i.e log file folder) in
- I have set the XML file as a data server (which test connects OK) and created physical and logical schemas in Topology Manager
- In Designer, have created a data model for this file

What I am trying to do is populate/refresh a global variable with a value from the XML file; however, when I make a change to the value in the XML file, the value does not get passed into the variable.

In the global variable, it is set to refresh from the xml data source and in a package I am using a variable step set to refresh but still the data does not update with the current values in the file.

Couple of other things - if I go to the data model and view the data, it sees the value that is in the xml file but the variable is not getting the same value - it seems to be using some kind of cached value. Also, if I close any open ODI apps (Designer, Operator, etc.) and re-open, the values (sometimes) seem to reflect what is in the file.

Crux of the post - am I missing something so obvious that I cannot see it or has anyone else experienced this kind of issue.

Thanks,

Gee

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details