I have a progress .p. I run some business logic in Progress DB. But I need to fetch some data from an Oracle DB. What are the different ways by which we can fetch the Data from an Oracle DB to a progress procedure.
You can use Openedge Dataserver to pull all the objects and data from oracle DB to your progress schema holder.
steps:
1) Create an empty db in OE.
2) Go to Data Administration --> DataServer --> Oracle Utilities
3) Give required details and select the objects need to be pulled after giving oracle authentication details
You need to have 'Openedge dataserver for oracle' component to use this feature along with your openedge installation.
For more details you can refer to below link-
Regards,
Santosh
What is Data Direct ? Will it possible to use Data Direct for the Oracle DB Connection from Progress
You can connect to the oracle db using data direct driver but you cannot perform all the operations.
As you mentioned you want to execute some .p after connecting to oracle db, you should have 'openedge dataserver for oracle' license with you to use the feature.
HTH
Santosh
rrajan wrote:
I have a progress .p. I run some business logic in Progress DB. But I need to fetch some data from an Oracle DB. What are the different ways by which we can fetch the Data from an Oracle DB to a progress procedure.
why fetching it from the database? there sure is an application that 'owns' that database... use it's published services instead, they might already have what you're looking for or can simply ask them nicely to expose the data you need through a new service
otherwise it's not the best idea to tight yourself to their 'internals' neither very polite... but that's a question of taste while skip over application business logic (including authentication/authorization) is something they should not let you do in the first place
yes, data server can let you do that but just because you can doesn't mean you should.
Thanks for the response. Is it possible to just run a sql statement and get the records from oracle using datadirect ? Do we have any sample programs in progress documentation ?