iBase 10.1.0: the important updates
Below we introduce the latest release of iBase 10.1.0.
Designed to bring more value, speed, and simplicity to your work, this release reflects the feedback and ideas you’ve shared with us.
This article highlights the most important updates.
Important notices
⚠️ Certificate signing authority
We have updated the certificate signing authority for iBase 10.1.0. If your systems restrict which certificate authorities are trusted, you will need to update your systems to recognize the new authority.
⚠️ User names - i2 iBase logins
If your iBase logins have a username format of ABC(123) you should not upgrade to iBase 10.1.0. Contact support@dataexpert.nl for guidance.
⚠️ Upgrade to iBase 10
The iBase 10 installer requires versions prior to iBase 10.0.0 to be uninstalled before installation can proceed.
⚠️ Upgrading iBase databases
Existing iBase databases used with iBase 8.9.13 or later can be upgraded directly to iBase 10.1.0.
For iBase versions 8.9.13 or later the database will be upgraded by opening in iBase 10.1.0 Designer.
For versions prior to iBase 8.9.13, contact support@dataexpert.nl for guidance. Once upgraded the database will not be accessible from previous versions of iBase.
⚠️ After upgrading to iBase 10 existing scheduled Search 360 jobs may fail
The file path to 'i2.iBase.SearchIndexerExe.exe' has been changed in iBase 10. For further details and solution see i2 Technical Memo.
⚠️ iBase 10 GIS-interfaces
NEC Software Solutions (formarly Northgate Public Services) hhave not yet released an iBase interface which provides compatibility with iBase 10; when available, customers should request this from NEC Software Solutions directly. Esri ArcGIS Desktop is not supported (all versions). MapInfo Professional 2021 and earlier versions are not supported. The structure and content of the mapping.cfg has been changed for iBase 10. This file is used to configure the iBase GIS interfaces and is usually located in C:\ProgramData\i2\i2 iBase\"language code"\Mapping. Do not overwrite with a mapping.cfg file from a previous version of iBase as it will not be compatible.
⚠️ iBase 10 Microsoft SQL Server Support
iBase 10 does not support Microsoft SQL Server 2016.
⚠️ iBase 10 changes to importing
iBase is now a 64-bits application. In order to import data from OLE DB data sources, 64-bit OLE DB drivers must be installed on client computers.
- Pre-existing import specifications for OLE DB data sources might error if the 64-bit drivers are not installed.
- The OLE DB Import Specification Updater tool can be used to update the connection details for multiple pre-existing import specifications where the OLE DB driver has changed name between the 32 and 64-bit versions.
The Date and Time auto-detection feature of the importer might give different results to previous versions of iBase; this is due to a change in the methods used to parse dates and times. While we have endeavoured to match the previous behaviour, differences are most likely to occur if the dates and times in the source data are in different format to the regional settings.
⚠️ Sentinel RMS-license Manager
Analyst's Notebook 10 customers using network-based licensing must upgrade to the Sentinel RMS License Manager 10.2.0 supplied with iBase 10 to use network licensing with iBase. Even if they previously installed the License manager belonging to Analyst’s Notebook 10.
Features
Release Highlights
Entra ID Single-Sign-on (v10.1.0)
iBase 10 single sign-on adds support for Microsoft's Entra ID access management system, in addition to Windows Active Directory. If transitioning from Windows Active Directory to Entra ID iBase can work in "Mixed Mode" to authenticate against the currently available system.
Stability and performance improvements (v10.0.1)
- This release of iBase provides stability and performance improvements.
- In addition this release of iBase does provide fixes for a number of faults, details may be found in the List of fixed issues.
Support for Esri ArcGIS Pro 3.4 (v10.0.1) (v10.0.0)
- Support for Esri ArcGIS Pro 3.4 in addition to 3.1, 3.2, and 3.3; added in iBase 10.0.0 Fix Pack 1
- ArcGIS Pro integration is available directly from iBase, and from Analyst's Notebook when it is installed with iBase
- To use Esri ArcGIS Pro with iBase, first install the ArcGIS interface from the GIS Interfaces option in the custom install menu of the iBase installer, and then install the separate i2 iBase ArcGIS Pro Add-In using its own installer
64-bit support (v10.0.0)
iBase is now 64-bit to allow it to take advantage of the modern 64-bit operating system and hardware.
Modernized icon set (v10.0.0)
- The icons in iBase have been updated with all new icons to give iBase entities a more modern look.
- Additional icons have been introduced to cover inclusion and diversity, business process modelling (BPMN), as well as new technologies, social media, dating apps, crimes and activities.
- Note that the additional icons require a custom iconlist to make them available for use in iBase database schemas.
- The icons from iBase 9 are available as legacy icons; and replace the previous set of legacy icons that have now been removed.
Importing Enhancements (v10.0.0)
- When creating an import specification for a text file the importer automatically determines the default field delimiter based on the source data.
- Changes to existing import specifications can be saved from any page of the import wizard, removing the need to navigate to the final page before saving.
- Saved import specifications can now be run directly from the database explorer or list views, it is no longer necessary to open an import specification to run it.
- Two new field actions have been added:
- Change Capitalization - converts the case of source data to all UPPER CASE, all lower case, First letter capitalized, or tOGGLES the data capitalization.
-
- Copy value from previous row - replaces the value in a column with the value in the row above from the same column. In combination with a condition statement this can be used to apply new values for inconsistently recorded source data for example.
- The Prefix/Suffix with another column, Find and Replace, and Trim Characters field actions, now include options to use tab and return either as separators or as match/trim characters.
- The bulk import feature no longer requires the database to be activated for bulk importing.
- The OLE DB Import Specification Updater tool is now available from both iBase User and Designer. It is used to update the OLE DB connection properties in multiple existing import specifications at the same time. For example, it can be used to update multiple OLE DB import specifications where the OLE DB driver name has changed name between the 32 and 64-bit versions of the drivers.
Excel export improvements (v10.0.0)
- Microsoft Excel is not required to be installed to use the export to Excel feature of iBase, allowing structured Excel exports to be created without installing additional software.
- Export to Excel provides performance and reliability improvements over previous iBase versions.
Improved reporting (v10.0.0)
- iBase standard reports are now generated and opened as PDF files making it easier to share them.
- Reporting using Microsoft Word templates adds new and refined Word template "styles" to improve report layout and icon/image positioning. Details of the additional styles may be found in the User Guide example Word templates. (My Documents\i2\i2 iBase\Examples > User Guide Database)
- iBase 10 offers improved reporting performance compared to previous iBase versions.
Updated scheduler logging (v10.0.0)
- The iBase scheduler for batch imports and exports now uses the NLog logging framework to record actions and outcomes from the scheduler service. The output of the logging is by default stored in a daily archived csv file accessed from the View Log Files button in the scheduler configuration tool (note that this replaces the previous View Logs button and viewer in the tool). For basic viewing of the log files use spreadsheet or text editing software.
- The use of the NLog framework allows customers with more advanced log viewing and analysis systems to make the scheduler service logging compatible with their systems; for example, the logs can be written to a central log aggregation and analysis server, or in a format readable by other log analysis tools, or written to a database.
- Scheduler service logging is configured with the NLog.config file in the iBase installation folder. The default file provided will output a daily archived csv file.
- Examples and customization options are detailed in the comments in this file. For further information on customizing logging rules and outputs see Configuration File.
- Updated Security (v10.0.0)
- iBase 10 now supports FIPS (Federal Information Processing Standards) without the need to create iBase databases specifically for FIPS environments.
- TLS 1.3 support has been added. • When iBase 10 creates or upsizes an iBase database to a new SQL Server database it will create a unique Data Access Token (DAT). The unique DAT improves the security of iBase databases. • iBase (User and Designer) no longer use the Data Dynamics Active Bar ActiveX control.
Updated Prerequisites (v10.0.0)
- iBase 10.0.0 requires either the Microsoft 365 Access Runtime redistributable (64-bit) or Microsoft Access (64-bit) from a supported version of Microsoft Office (2019, 2021 or 365) to be installed on the iBase client.
- Microsoft .NET Framework 4.7.2 is required.
- Other pre-requisites from previous iBase versions are no longer required.
License Management (v10.0.0)
- The new license management mechanism within iBase 10 helps to ensure that the product is used within the terms of the license agreement. License management supports standalone, network, or cloud based licensing.
- For more details see Licensing information or send an email to Support@DataExpert.nl. We can help you make the right choice and provide you with the necessary licenses.
Note Standalone licenses are not supported when using Remote Desktop Services. The extensive release notes and the latest FixPack you can find here
When additional support is required please do not hesitate to contact us at support@dataexpert.nl