Notice: This Wiki is now read only and edits are no longer possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Connecting to Ingres"
(→Instructions for how to connect to an Ingres database using DTP) |
|||
| Line 1: | Line 1: | ||
[http://www.ingres.com/ '''Ingres''']'''is the leading business open source database- check it out!''' | [http://www.ingres.com/ '''Ingres''']'''is the leading business open source database- check it out!''' | ||
| − | == Instructions for how to connect to an Ingres database using DTP inside Eclipse<br> == | + | == Instructions for how to connect to an Ingres database using DTP inside Eclipse<br> == |
1. Create your driver profile | 1. Create your driver profile | ||
| − | #Open Window-Preferences-Data Management-Connectivity-Driver Definitions.<br> | + | #Open Window-Preferences-Data Management-Connectivity-Driver Definitions.<br> |
| − | #Click "Add". | + | #Click "Add". |
| − | #Select "Ingres JDBC Driver" from the list of drivers. | + | #Select "Ingres JDBC Driver" from the list of drivers. |
| − | #Click the "Jar List" tab. | + | #Click the "Jar List" tab. |
| − | #Click on "iijdbc.jar" and click "Edit". | + | #Click on "iijdbc.jar" and click "Edit". |
| − | #Browse to your iijdbc.jar file. You can download it here. | + | #Browse to your iijdbc.jar file. You can download it here: [http://community.ingres.com/wiki/Ingres_JDBC_Driver_Downloads http://community.ingres.com/wiki/Ingres_JDBC_Driver_Downloads] |
| − | #Click "Ok" to close the Driver Definitions box.<br> | + | #Click "Ok" to close the Driver Definitions box.<br> |
#Click "Ok" to close the preferences window. | #Click "Ok" to close the preferences window. | ||
2. Create your connection profile | 2. Create your connection profile | ||
| − | #Open Window-Show View-Other-Data Management-Data Source Explorer-Ok. | + | #Open Window-Show View-Other-Data Management-Data Source Explorer-Ok. |
| − | #In the newly opened Data Source Explorer, right-click on Database Connections and choose "New...". | + | #In the newly opened Data Source Explorer, right-click on Database Connections and choose "New...". |
| − | #Select "Ingres". | + | #Select "Ingres". |
| − | #Click "Next". | + | #Click "Next". |
| − | #Use the dropdown to choose the Ingres Driver you just configured. | + | #Use the dropdown to choose the Ingres Driver you just configured. |
| − | #The JDBC URL will autopopulate. You most likely will not need to change it. | + | #The JDBC URL will autopopulate. You most likely will not need to change it. |
| − | #Click "Test Connection" to verify that you can connect. | + | #Click "Test Connection" to verify that you can connect. |
| − | #Click "Finish". | + | #Click "Finish". |
#You'll now see your connection profile in the Data Source Explorer under Database Connections. | #You'll now see your connection profile in the Data Source Explorer under Database Connections. | ||
| − | <br> | + | <br> |
For more information, visit the Ingres Community Wiki here: [http://community.ingres.com/wiki/Eclipse_DTP_How_To http://community.ingres.com/wiki/Eclipse_DTP_How_To]<br> | For more information, visit the Ingres Community Wiki here: [http://community.ingres.com/wiki/Eclipse_DTP_How_To http://community.ingres.com/wiki/Eclipse_DTP_How_To]<br> | ||
Latest revision as of 15:09, 7 July 2010
Ingresis the leading business open source database- check it out!
Instructions for how to connect to an Ingres database using DTP inside Eclipse
1. Create your driver profile
- Open Window-Preferences-Data Management-Connectivity-Driver Definitions.
- Click "Add".
- Select "Ingres JDBC Driver" from the list of drivers.
- Click the "Jar List" tab.
- Click on "iijdbc.jar" and click "Edit".
- Browse to your iijdbc.jar file. You can download it here: http://community.ingres.com/wiki/Ingres_JDBC_Driver_Downloads
- Click "Ok" to close the Driver Definitions box.
- Click "Ok" to close the preferences window.
2. Create your connection profile
- Open Window-Show View-Other-Data Management-Data Source Explorer-Ok.
- In the newly opened Data Source Explorer, right-click on Database Connections and choose "New...".
- Select "Ingres".
- Click "Next".
- Use the dropdown to choose the Ingres Driver you just configured.
- The JDBC URL will autopopulate. You most likely will not need to change it.
- Click "Test Connection" to verify that you can connect.
- Click "Finish".
- You'll now see your connection profile in the Data Source Explorer under Database Connections.
For more information, visit the Ingres Community Wiki here: http://community.ingres.com/wiki/Eclipse_DTP_How_To