Deploying your own database

To use your own database in ION, first make the database driver available in the ION Service.

Because the program to register the driver is run externally, ION uses the standard JAVA_HOME environment variable available in the system. Therefore, you need a version of Java Software Developer's KIT, or JDK, that is installed and configured in the machine where you run the program. Ensure that you install JDK, not a Java Runtime Environment (JRE). The version of JDK you install must be supported by ION.

Note: Deploying your database driver in ION requires technical knowledge.

To deploy a specific JDBC driver in ION:

  1. Log on to ION Desk. Select Configure > ION Service.
    The Configure ION Service page is displayed.
  2. Click the Configuration Files tab.
  3. In the Custom database drivers section, click Download wrapper.
  4. The Save As window is displayed. Specify the file name as BundleWrapper.zip and click Save.
  5. The zip file is downloaded at the selected location. A message that the file is downloaded is displayed. Click OK.
  6. Unzip the BundleWrapper zip file. If possible, extract the BundleWrapper in C:\temp. If you use a different location, see the InstallPath property in step 3.
  7. Copy the custom driver jar to the BundleWrapper\OriginalJar folder.
    If there are multiple jar files, create a single flat jar using the procedure explained above and use that file instead.
  8. Change the properties.txt file to reflect the driver specifics.
    See Properties.
  9. Run build.bat. A zip file is generated. This zip file is required to start up the bundle.
  10. Complete these steps:
    1. In ION Desk, select Configure > ION Service. Then click the Configuration Files tab.
    2. In the Custom database drivers section, click Upload.
    3. Upload the zip file.
    If the upload is successful, a message that the file is uploaded is displayed. The entry is displayed in the list of Custom database drivers.
Now you can model your Infor Application connection point or the database connection point using the new DB vendor. You do not have to stop or restart the ION Service.