Avatar of Pau Lo
Pau Lo
 asked on

openedge/progress database browser

Does anyone have any experience of administration of openedge ( which I believe was previously progress), databases, and whether there are any free tools which could be used to browse the data of some orphaned database files believed to have once upon a time been associated with an openedge/progress database?
Databases

Avatar of undefined
Last Comment
efrimpol

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Daniel Pineault

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
David Favor

The psql command is the equivalent of the mysql command line tool.

You can use psql in scripts or to dump database/table schema or row data.

Or you can use https://www.pgadmin.org/ for a GUI tool.
Pau Lo

ASKER
can psql and pgadmin work with openedge/progress database files, they seem geared towards postgresql which I thought was something totally unrelated.
Pau Lo

ASKER
will look into ODBC via access, its just a new format to me also, and doesn't seem to be a single file like you get with SQL Server and Access databases, so its almost what do you connect to.
Your help has saved me hundreds of hours of internet surfing.
fblack61
efrimpol

https://www.progress.com/openedge

I am not an OpenEdge Admin, but I do know that when using MsAcess ODBC drivers, this will allow you to see the contents of various tables in the database.

However, for this to work, you need to install and configure the Progress ODBC drivers. And in order for that to work, the database must be mounted and in a running state and the permissions need to be set.

For ODBC to work, you will need the DSN (Data Source Name) - which is really just a name that you give the ODBC, description (could be anything), the host name (the name of the server), the port (usually 9100), the Database Name (this the name of the actual mounted database), and the User ID (this is not the windows network id, this id is set within OpenEdge).

OpenEdge is extremely similar to SQL and if configured correctly, you will be able to access all the tables.
David Favor

I think I was mistaken. I misread Progress as Postgress. Two completely different beasts.

Likely efrimpol's suggestion will be a good starting point for you.
efrimpol

You can also try the users community:

https://community.progress.com/
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.