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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
can psql and pgadmin work with openedge/progress database files, they seem geared towards postgresql which I thought was something totally unrelated.
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.
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.
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.
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.
Likely efrimpol's suggestion will be a good starting point for you.
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.