mkendrick
Member
I've done this before in XE. I'm at a client that's moving from world to E1 8.10. They have extensive integration with other systems that must happen in real time. Mainly validation of data in external systems.
I think that the unicode datasources are a factor but I can't find a way around it right now.
The method I used before was to create a OW table that mimicked the external table. Generate then drop the table and create a view against the external table that matched the OW definition. I tried that and I also created a non unicode datasource that points to an external(non-jde) library I then created the view. I get the same results as when I created the view in testdta... I get data in the UTB only when I uncheck the 'format data' option.
I have discovered that if you are required to un-format the data you will not get records returned to OW ER code.
I last resort would be to replicate the data at a SQL level. I would prefer to just fetch the records from the source.
Thanks,
Mark Kendrick
I think that the unicode datasources are a factor but I can't find a way around it right now.
The method I used before was to create a OW table that mimicked the external table. Generate then drop the table and create a view against the external table that matched the OW definition. I tried that and I also created a non unicode datasource that points to an external(non-jde) library I then created the view. I get the same results as when I created the view in testdta... I get data in the UTB only when I uncheck the 'format data' option.
I have discovered that if you are required to un-format the data you will not get records returned to OW ER code.
I last resort would be to replicate the data at a SQL level. I would prefer to just fetch the records from the source.
Thanks,
Mark Kendrick
