Considerations and Limitations
|
Topics: |
This section provides an overview of the considerations to be taken into account while using Omni-Gen™ Personal Edition. You are reminded that this product is designed for personal use and may carry limits for data load, data processing, and other limitations. For more information on the Enterprise Level Omni-Gen™ Master Data Management and Omni-Gen™ Data Quality Editions, contact iWay Customer Support.
Note:
- Installation into the Program Files directory is not supported. It is recommended that you use any other location of the root drive.
- Omni-Gen™ Personal Edition supports Microsoft Excel data sets (spreadsheets) up to 3 MB. If you need to work with larger data sets, it is recommended that you export your Microsoft Excel data set to CSV format. If you require any additional support with your data sets, contact iWay Customer Support.
Microsoft Visual C++ 2010 SP1 Redistributable Package (x64)
Omni-Gen™ Personal Edition Release 3.9 and higher requires Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) to be installed on the target machine. The current Omni-Gen™ Personal Edition installer is not able to automatically install this package. If the target machine does not have this package installed, then you must download and install this package before running the installer. You can download Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) from the following Microsoft website:
https://www.microsoft.com/en-ca/download/details.aspx?id=13523
Data Source Names
The product currently supports file-based data source names that do not contain special characters. Supported data source names must contain the following characters:
- A-Z
- a-z
- _
- 0-9
The maximum length for a data source name is 35 characters.
SQL Server Non-dbo Schemas
To load data from a table on SQL Server that is outside of the default dbo schema, you must have the appropriate permissions configured on SQL Server to access another schema (other than dbo schema). This setting is controlled by SQL Server configuration settings for a specific user, and not by Omni-Gen™ Personal Edition.
Windows Defender
During installation of Omni-Gen™ Personal Edition, you may encounter a message from Windows Defender or similar protection applications to allow access for PostgreSQL server and other Omni-Gen™ Personal Edition services. The following image is a sample that you may encounter from Windows Defender, where you are advised to select the Allow access option.
Excel Data Support
Excel data sources can contain many types of data, including formulas, charts, pictures, and others. This release of Omni-Gen™ Personal Edition supports only traditional simple Excel data and does not provide support for formulas. If the data source contains formulas or any other unsupported component, the data cell will be skipped during import, and a corresponding error message will be generated for you to review.
Support for the Datetime Datatype
During the data import process, the Datetime datatype columns may experience a nullification of milliseconds in the Date Time value. The milliseconds value may be turned into .000 when viewing the data in the Data Profiling screen.