hello ,
i need to connect OpenEdge Editor with Postgre Sql Database. can anyone tell me how to connect OpenEdge Editor with Postgre Sql.
Can you please explain your use case more fully? Are you asking if the DB Navigator in Progress Developer Studio can add PostgreSQL as a database to explore, or are you asking if you can access PostgreSQL natively from ABL code in the ABL editor (or Procedure Editor)? (For the later, you would need to use DataServers in OpenEdge, and unfortunately, there is no PostgreSQL DataServer).
If you have a particular use case in mind, the ODBC Bridge (in 11.3.2) might be an option.
Can you please explain your use case more fully? Are you asking if the DB Navigator in Progress Developer Studio can add PostgreSQL as a database to explore, or are you asking if you can access PostgreSQL natively from ABL code in the ABL editor (or Procedure Editor)? (For the later, you would need to use DataServers in OpenEdge, and unfortunately, there is no PostgreSQL DataServer).
If you have a particular use case in mind, the ODBC Bridge (in 11.3.2) might be an option.
Flag this post as spam/abuse.
Hello,
I am curious if you meant "Progress database" instead of "PostgreSQL database".
If you meant "Progress database", the following thread provides some suggestions on how to connect to the Progress/OpenEdge database:
community.progress.com/.../36151.aspx
Could you provide more information on your use case?
Thanks.
Hello,
As per my use case I have a postgresql db with customer table and its related fields like custID, Name, city etc...
Now as I am using Progress 4GL in my business logic, want to access above db and customer table in my ABL program.
After accessing the postgresql db, it should be accessed like progress db.
Kindly help to provide details steps/options.
Hello,
As per my use case I have a postgresql db with customer table and its related fields like custID, Name, city etc...
Now as I am using Progress 4GL in my business logic, want to access above db and customer table in my ABL program.
After accessing the postgresql db, it should be accessed like progress db.
Kindly help to provide details steps/options.
What you are asking is very uncommon and I have personally never heard of this before. I believe the previous answers on this thread cover the options.
But generally speaking you can't natively have the ABL interact with a PostgreSQL db the same way it interacts with on OpenEdge db. =
Dear Brian,
Could you please help me to get the DataServer references or steps to use this?
Dear Brian,
Could you please help me to get the DataServer references or steps to use this?
Flag this post as spam/abuse.
Note that the DataServers are their own product, separately licensed. So, unless you have it already, you are going to have to buy a license. I don't know if the DataServers are in the eval, but if not, you could get an eval from your rep to try out.
Dear Brian,
Could you please help me to get the DataServer references or steps to use this?
Flag this post as spam/abuse.
Flag this post as spam/abuse.
you might want to have a look at the instructions. specifically, the OpenEdge Data Management:DataServer for ODBC book. chapters 3 and 4 are what you need to get going.
Pretty sure the ODBC Dataserver was deprecated, so, using that as a part of the solution is not future proof.
Hello [mention:b6d566560a694a34aa380e40fccecb1a:e9ed411860ed4f2ba0265705b8793d05] , did you success connecting to PostgreSQL?