IBM i2 iBase

IBM i2 iBase Courses:

Formatting i2 iBase Import Data for Phone Numbers

This video shows you how you can use iBase to convert phone numbers using format logic into the following different formats:

  • If a phone number is 10 characters long, the format will be (999) 999-9999
  • If a phone number is 7 characters long, the format will be 999-9999
  • If a phone number is any other length than 7 or 10 characters, then leave as is 9999999999.
This video uses United States phone number formats as the example. However, this format logic can also be used for international phone numbers.

Time: 24 minutes

i2 iBase - Assign icons

This video shows you how to use the Assign Icons function in iBase. Use Assign Icons to specify an icon (or change the icon shade color) to:

  • an entity
  • the result of a Query
  • a set
Duration: 12 minutes

IBM i2 iBase - Importing documents and pictures with the import specfication

This video shows how to import records with attached pictures or documents in iBase using the Import Specifications.

For example, you may want to import Persons records with an ID picture for some of the records..

Also, you may have some Entity or Link types with a Document field type, and you want to import new records with their attached documents.

Duration: 13 minutes

i2 iBase - Create multiple links

This video explains the multiple links function in iBase, which is located in the iBase New menu.

This function allows you to quickly and rapidly create multiple links between one specified entity and a group of other entities.

Duration: 7 minutes

i2 iBase - Fix display problem

Depending on your screen size and resolution, you might experience some display problems on both iBase User and Designer.

These problems are small icons, with a black frame on the top and right part of some icons.

This video will help you fix this display problem, and, have the expected display when using iBase.

Duration: 4 minutes

i2 iBase - Must gather information for IBM i2 Support

The IBM i2 Product Support team takes you through the i2 iBase product must gather information you may need to provide to get assistance with your support case.

Duration: 7 minutes

i2 iBase - Opening iBase after IDS/IDB files were moved

In this video, Jean-Jérôme Casalonga, from the IBM i2 Support team, explains how to open an iBase database if the IDS and/or the IDB files are moved or copied to a different folder.

The internal security of iBase prevents a user from opening an iBase database if the 2 files are not in the expected folder. Only a user with Administrative privileges in iBase can validate the change of location, allowing the users to open the iBase database with any issue.

Duration: 5 minutes

i2 iBase - Soft delete feature

This video shows you how to use the Soft Delete feature of the IBM i2 iBase software.

This feature allows you to be able to restore deleted records, if the records were deleted accidentally.

Duration: 10 minutes

IBM iBase 9 - Cyber IP DNS Removed

In this video, the IBM i2 product support team shows us the difference between an i2 iBase installation with and without the Cyber IP DNS Feature present.

i2 Open Mic - Upgrading and Migrating i2 iBase


  • Define the environment for upgrading and migrating
  • Provide the best practices to use for upgrading and migrating
  • Know the steps to upgrade and migrate i2 iBase
  • Understand what changes you need to make before a backup of the database
  • Know how to perform the datasbase backup and restore
  • Provide steps to configure the database
  • Understand how to restart Search 360 and Alerts


46 minutes

IBM i2 iBase - Creating and Importing a SQL View into IBM i2 iBase

The two videos provide a walk-through on:

  • how to create a SQL view to import into IBM i2 iBase, and
  • how to import the SQL view into IBM i2 iBase

IBM i2 iBase 9 Translation (How To)

This video explains how to translate all or part of the IBM i2 iBase 9 software. Some new features of iBase 9 have not yet gone through the IBM translation process. You can use this video to translate iBase into your own language if your language is not one of the 12 available (English, Arabic, French, Italian, Spanish, Russian, Polish, Simplified Chinese, Traditional Chinese, Czech, Japanese, German and Portuguese-Brazilian). This translation process can be done manually, but we recommend using an automatic online translation tool.

IBM i2 iBase - Move and Restore an iBase SQL Server Database

In this video, you will learn how to move and restore an iBase SQL database from one server to another server. You will be using the IBM i2 iBase Designer to perform this move and restore.

IBM i2 iBase 9 - Upgrade and Migration Guide

In this IBM i2 Support video, Dan Brace from the IBM i2 product support team will take you through a sample upgrade and migration of the newly released IBM i2 iBase 9 product.

iBM i2 iBase 9 - Audit Viewer Save Filters

This video will explain how you can now save the Filters you define in the IBM i2 Audit Viewer 9 software.

In the IBM i2 Audit Viewer, you can specify filters to only see the Logs that interest you.  You can filter by dates, times, actions, user, record, and so forth.

In this new release of the IBM i2 Audit Viewer, you can now save the filters you define, so that you can easily recall them, without having to redefine them from scratch each time.

IBM i2 iBase 9 – Composite Indexes

This video will explain how to create composite indexes in the IBM i2 iBase 9 software.

  • Part 1 explains what composite indexes are.
  • Part 2 explains why creating composite indexes in iBase 9 can help speeding up imports.
  • Part 3 shows an example of creating a composite index using the “Suggestions” button. This will create composite indexes based on Import Specifications, and more specifically, based on fields that are defined as Identifiers in the Import Specification.
  • Part 4 shows how to manually create a composite index that does not rely on an import specification.
  • Part 5 shows another example of manually creating a composite index, based on the Discriminator fields of one Link type.

Important: The Composite Indexes is mainly useful when you have more than one discriminator fields in one Entity or Link type.

IBM i2 iBase 9 – Revert function

This video will explain how to use the Revert feature in IBM i2 iBase 9.

This feature is only available if you are using an SQL Server iBase format database or you enable the Audit History feature (in iBase Designer, Database properties)

The Revert function allows you to visualize the different versions of a record (Entity or Link), see the changes, and then choose to revert the record to one of the previous versions. This might be useful if, for example you made a mistake, and the wrong changes were saved.

IBM i2 iBase 9 – Transform a Find into a “Create Entity” or a “Create Query”

This video will explain how to use one new feature of IBM i2 iBase 9.

This feature allows you to convert a "Find" into either a “Create Entity” or a “Create Query”. Before creating a new Entity record, it is advisable to start by checking if this entity already exists or not in the Database. To do so, you’ll use the Find function of iBase to check if this record already exists. If it does not exist, you now don’t need to close the Find window and open the Create Entity record to retype everything. You can simply click on the “Create Entity” button at the bottom-left of the Find window. This will open a new window, with the fields pre-filled with the valued you used for the Find. If you don’t want to create a record, you can transform the Find into a visual Query in iBase, by clicking on the “Create Query” button.

This new iBase 9 feature will speed up your workflow when entering data.

IBM i2 iBase 9 - Create Audit Log Journal Entries

This video will explain how you can create Audit Log Journal Entries in IBM i2 iBase 9 and IBM i2 Analyst’s Notebook V9.2.2. This feature is only available if the iBase database has an Audit level of at least 3.

From iBase, or from ANB, you can now create Audit Log Journal Entries. These are small text fields that, for example, will allow you to record what you are working on, or if you have some valuable information that relates to the use of the iBase database. The Journal entries can then be read in the IBM i2 Audit Viewer software. In this same software, you can also enter new journal entries.

IBM i2 iBase 9 - Audit Viewer - Set Membership

This video will explain one new feature of the IBM i2 Audit Viewer 9 software.

This feature allows you to add an extra level of filtering on the Audit Viewer software. You can now filter the results on records that belong to one or several Sets (the Sets are defined in iBase User). For example, you can ask for “Give me all the Log entries between this date and this date, from this user, with the records belonging to the Sets S1 and S2.”

This new “Set membership” feature can also work with the new Save Filters function of IBM i2 Audit Viewer 9.

IBM i2 iBase 9 – Merge Links

This video presents a new feature of the IBM i2 iBase 9 software. You can now merge links between 2 entities.

The links you want to merge must:

  • Have the same Entities as ends
  • Be of the same Link type

You must then select the link that will be the target for the merged links, and of course, you must select the links that you want to merge into this target link.

Important: Once merged, you cannot unmerged the links.

i2 iBase 9 – Field-level metadata

This video presents 3 new features of the IBM i2 iBase 9 software.
When working on an SQL Server format iBase, you can now add 3 metadata items for each field for the Entities and Links:

  • Field Attachments
  • Field Confidence
  • Field Security
Each of these Field metadata items can be enabled and disabled independently in your iBase database.  This is done in iBase Designer. Field Security adds an SCC pick list to each field (you must have defined an SCC pick list first, and you must have defined Red Keys groups in iBase Designer).
  • The Field Confidence adds a confidence value to each field. This allows you to specify the level of Confidence you have in the value of one field.
  • Field Attachments allows you to attach a file (any file type) to a field.
  • For Field Security, the overall SCC value for the record is set by the most restrictive field level SCC value.

i2 iBase 9 – Advanced Subsets - Creation

This video shows how to create IBM i2 iBase 9 Advanced Subsets, which is one of the new features of iBase 9.

In this video, you’ll learn the steps to create iBase 9 Advanced Subsets, including:

  • Define Subset definitions (using Queries and/or Sets)
  • Provide a name for the Advanced Subset, specify the target SQL Server
  • Specify the destination folder and the subset identifier

Please note that only users that have the “Create database” roles in iBase Security can create an iBase subset.
Warning : you must not change the schema of the database subset, or synchronization will not be possible anymore.

i2 iBase 9 - Advanced Subsets Introduction

This video introduces the IBM i2 iBase 9 Advanced Subsets, which is one of the new features of iBase 9. In this video, you’ll learn what are the prerequisites for the iBase 9 Advanced Subsets, including:

  • The master DB must be in SQL Server format
  • The Security file must also be in SQL Server format
  • The Soft Delete must be enabled

The Advanced subsets can hold up to 5 million records. They are stored in an SQL Server format. You can enable Search 360 and the Alerts for the Advanced Subsets. The Record History and Auditing are maintained across Master and Subsets databases.

IBM i2 iBase 9 - New Features and Support

Dan Brace, from the IBM i2 Product support team, takes us through some of the new features of the IBM i2 iBase 9 product which includes:

  • New Supported Software
  • Fast Database Switching
  • Active Directory Support
  • Deployment Features
  • Disabling the database information screen at startup
  • Data entry memos
  • Image support
  • Datasheets
  • Pick Lists
  • Spellchecking
  • Improved Form Reset capability
  • Set Combine and Analyze Improvements
  • FIPS Compliance

i2 Analyst's Notebook: How to Add Entities to an ESRI Map Using i2 iBase


  • Understand how to prepare entities so that you can place the entities in an ESRI map using iBase
  • Know how to move the entities into an ESRI map in Analyst's Notebook


12 minutes

i2 Analyst's Notebook - How to Add Entities to an ESRI Map


  • Understand how to place entities on an ESRI Map
  • Know how resolve an issue if the entity does not appear on the map


6 minutes

i2 Analyst's Notebook and Premium 9.0.0 What's New - Part 2


This video is part 2 of a two part series on what's new in version 9.0.0 of i2 Analyst's Notebook and i2 Analyst's Notebook Premium.  In this video, you will be shown how to:

  • connect data sources to i2 Analyst's Notebook
  • access information in i2 Analyze through the Intelligence Portal
  • access data from i2 i Base database
  • move i2 Analyst's Notebook task panes
  • use the File menu options
  • access and change the quick access bar menu
  • hide the i2 Analyst's Notebook ribbon interface


22 minutes