>Just had a project's requirements changed. What else is new?. I could use some suggestions though.
>Problem:
>redesign project (local personell management system) to avoid duplicate data entry with a national database system (PepoleSoft). Acces to national system may only be done staticly, i.e comma delimited daily output of desired fields.
>
>Some suggestions on how to implement this would realy be appreciated, i.e how to maintain data integraty, best way of getting static data from natonal system. ( I'd like replication or similar, but getting that from Ottawa may be a problem )
>
>Thanks in advance for your suggestions
First, try to convince the National DB manager to grant select only priviliges on just the data you need. Explain that this is really no different than getting the data in an exported file. If that fails, then you have to develop a procedure to import the file they provide to you. You would have to create the Oracle tables yourself to insert [or update] the data into.
If you gained select privileges, you could then create views in your schema. Are your requirements providing personnel updates back to the national DB?
Mark McCasland
Midlothian, TX USA