Release notes - iBase 10.0.0

• iBase is now 64-bit to allow it to take advantage of the modern 64-bit operating system and hardware.

• 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.

• 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 Text 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.

• 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.

• 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.

• iBase 10 offers improved reporting performance compared to previous iBase versions.

• Provides support for Esri ArcGIS Pro 3.2 and 3.3 in addition to 3.1, allowing iBase data to be displayed on a map and analyzed within Esri ArcGIS Pro.

• 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.

• 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.

• 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.

• 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.

• 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.

Note Standalone licenses are not supported when using Remote Desktop Services.