Topics: |
As of Omni-Gen version 3.2 and higher, a new wizard-based installer is provided, which simplifies the installation and configuration process. The user needs to download the installer applicable to their version and platform. The installation must be running with Administrative privileges to ensure that it has access to all required service configurations.
This install does not provide a pure upgrade functionality in terms of overlaying on top of the existing Omni-Gen 3.x release. The installation is meant to be a parallel process and then a migration of artifacts. It is important to note that if you install into the same directory, you may lose your configuration as configuration files will also be replaced in addition to the binaries. For more information, see the Omni-Gen™ Installer User's Guide.
Topics: |
This section describes a configuration update you can make during the installation or after the installation (by modifying your database settings in the Omni Console) to enable the usage of UTF-8 characters in Omni-Gen version 3.2 and higher.
By default, the installation uses the following JDBC URL format when configuring SQL Server 2016:
jdbc:sqlserver://hostname:port;databasename=db_name;sendStringParametersAsUnicode=false
To enable UTF-8 character support in your Omni-Gen environment, modify the JDBC URL to either of the following:
jdbc:sqlserver://hostname:port;databasename=db_name;sendStringParametersAsUnicode=true
or
jdbc:sqlserver://hostname:port;databasename=db_name;useUnicode=true;characterEncoding=UTF-8
This section provides a summary of operational considerations for users. For more information, see the Omni-Gen™ Operation and Management Guide.
To access the Omni-Gen Console, please use https://<host>.<domain>:<port> instead of a localhost URL (for example, https://mydesktop.ibi.com:9500).
To use Microsoft SQL Server as a repository database, you must use sqljdbc42.jar drivers.
To use Oracle as a repository database, you must have select permission on SYS.DBA.RECYCLEBIN. Otherwise, the deployment of the bundle will not be successful.
To use Db2 as a repository database, the following tuning steps are required. This is due to the nature of Db2 and its requirement for higher memory consumption during the deployment phase. If the memory is not increased, you might encounter an OutOfMemoryError exception when resetting the environment or the deployment phase.
For new installations:
For existing installations:
This section provides a short overview for the migration needed from prior 3.1.x versions to the version 3.2 and higher platform. For more information, see Appendix A in the Omni-Gen™ Installer User's Guide. Please contact iWay Customer Support for additional information and best practices.
Note: If you navigate to the Omni Deployment Web Console, you will not see any bundle deployed due to the new directory structure. If you install or deploy the new bundle using a web console, it will recreate your database and all prior data will be lost.
If you want to start with a clean environment, then ensure to complete the following:
The following database changes need to be considered when comparing Omni-Gen version 3.0.x with version 3.1.2 and higher. These are generic database change examples and may or may not apply to the specific deployment.
Area |
Omni-Gen Version 3.0.1 |
Omni-Gen Version 3.1.2 and Higher |
Note |
Action |
---|---|---|---|---|
Ramp |
source_instance_id_name |
SUBJECT_SIN |
Every Ramp table. |
|
Source/Instance/Master |
ORIGINATION CLEARANCE_CODE |
ORIGINATION_CODE CLEARANCE_CODE_CODE |
Every instance of code fields in the model. |
Reprocess Ramp batch to sync data or move data manually to new columns. |
Source/Instance |
PERSON_ID |
PERSON_PERSON_ID |
Every instance of link fields in the model. |
Reprocess Ramp batch to sync data or move data manually to new columns. |
As of Omni-Gen version 3.2 and higher, if you have existing Omni-Gen 3.0.x Data Quality plans, they must be updated as follows to meet the new structural requirements: