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

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

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