I found a great way for us lowly Progress users to get a Microsoft SQL-like interface to query and perform forensics on our databases and tables (and updates, too). It’s freeware and safe and it’s FAST. The client is “Squirrel SQLâ€.
If you are curious, download and follow my install instructions for us Progress folks...... Take about 10-15 mins. I’ve installed this on XP and W7-64 with no issues. The only prerequisite is that you need the Java Runtime Installed. (http://www.java.com/en/download/manual.jsp)
1. Download from here: http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.2.1/squirrel-sql-3.2.1-install.jar/download
2. Execute installation with all default options is OK.
3. Locate Squirrel Installation folder (C:\Program Files) and then open the subfolder “Libâ€
4. Open the \\<server>\epicor\oe101b\java folder and copy all “.jar†files into the “Lib†folder above. Do not overwrite any duplicate files.
- Replace <server> above with your Vantage server’s name.
5. Open Squirrel
6. Click on “Drivers†and then the “+†button to Add a new driver.
- Name = “OpenEdgeâ€
- Example URL = “jdbc:datadirect:openedge://<server>:10001;DatabaseName=mfgsys†(Replace <server> with your Vantage server; do NOT change the port here)
- Website URL = leave blank
- Class Name: “com.ddtek.jdbc.openedge.OpenEdgeDriverâ€
7. Click OK to Save the Driver info
8. Add an Alias: Click on the Alias tab in the left column and Click on the “+†button to Add a new Alias
- Name = give it a name... ie, “Vantage TEST†or “Vantage LIVEâ€
- Driver = Choose “OpenEdge†(should have a blue checkmark)
- URL = Should be a copy of the “Example URL†in Step 6; verify. Still leave the Port alone.
- User Name and Password should both equal “sysprogressâ€
- Click the “Auto Login†checkbox
- Click on “Properties†button
- On the Schemas tab, for best performance, select “Load all and cache all schemasâ€
- Click on Driver Properties tab and check the “Use Driver Properties†box
- Click the “Specify†checkbox for each of the following and fill in the appropriate value:
- ServerName = your Vantage Server
- User = sysprogress
- password = sysprogress
- PortNumber = your ODBC port (8350 for Live, 8370 for Test, 8380 for Pilot)... I made an alias for 3 of my environments...
Click OK and you should connect and be able to drill down into the Objects... MFGSYS..PUB..TABLE..etc From here you can browse the contents of the tables and edit values (be careful!).
Also the SQL tab allows you to write MSSQL queries and get results FAST. You can also do update statements.
- Select Top 100 * from PUB.PartTran
Exporting to Excel is super easy.
Vic
Vic Drecchio
Director of Information Technology
Swepco Tube
One Clifton Blvd, Clifton, NJ 07011
Email: vic.drecchio@...
Mobile: (704) 530-3092
[Non-text portions of this message have been removed]
If you are curious, download and follow my install instructions for us Progress folks...... Take about 10-15 mins. I’ve installed this on XP and W7-64 with no issues. The only prerequisite is that you need the Java Runtime Installed. (http://www.java.com/en/download/manual.jsp)
1. Download from here: http://sourceforge.net/projects/squirrel-sql/files/1-stable/3.2.1/squirrel-sql-3.2.1-install.jar/download
2. Execute installation with all default options is OK.
3. Locate Squirrel Installation folder (C:\Program Files) and then open the subfolder “Libâ€
4. Open the \\<server>\epicor\oe101b\java folder and copy all “.jar†files into the “Lib†folder above. Do not overwrite any duplicate files.
- Replace <server> above with your Vantage server’s name.
5. Open Squirrel
6. Click on “Drivers†and then the “+†button to Add a new driver.
- Name = “OpenEdgeâ€
- Example URL = “jdbc:datadirect:openedge://<server>:10001;DatabaseName=mfgsys†(Replace <server> with your Vantage server; do NOT change the port here)
- Website URL = leave blank
- Class Name: “com.ddtek.jdbc.openedge.OpenEdgeDriverâ€
7. Click OK to Save the Driver info
8. Add an Alias: Click on the Alias tab in the left column and Click on the “+†button to Add a new Alias
- Name = give it a name... ie, “Vantage TEST†or “Vantage LIVEâ€
- Driver = Choose “OpenEdge†(should have a blue checkmark)
- URL = Should be a copy of the “Example URL†in Step 6; verify. Still leave the Port alone.
- User Name and Password should both equal “sysprogressâ€
- Click the “Auto Login†checkbox
- Click on “Properties†button
- On the Schemas tab, for best performance, select “Load all and cache all schemasâ€
- Click on Driver Properties tab and check the “Use Driver Properties†box
- Click the “Specify†checkbox for each of the following and fill in the appropriate value:
- ServerName = your Vantage Server
- User = sysprogress
- password = sysprogress
- PortNumber = your ODBC port (8350 for Live, 8370 for Test, 8380 for Pilot)... I made an alias for 3 of my environments...
Click OK and you should connect and be able to drill down into the Objects... MFGSYS..PUB..TABLE..etc From here you can browse the contents of the tables and edit values (be careful!).
Also the SQL tab allows you to write MSSQL queries and get results FAST. You can also do update statements.
- Select Top 100 * from PUB.PartTran
Exporting to Excel is super easy.
Vic
Vic Drecchio
Director of Information Technology
Swepco Tube
One Clifton Blvd, Clifton, NJ 07011
Email: vic.drecchio@...
Mobile: (704) 530-3092
[Non-text portions of this message have been removed]