IBM i2 Base

IBM i2 Base 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 - 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

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

Perform a silent installation for i2 iBase and its components

This course explains how to perform silent installations for iBase and all iBase components. A silent installation lets you install a software program unattended.

Duration: 15 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 - 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 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

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.

{GENERICO:type="hints",style="Important",text="Please note that this feature is not retroactive : If you enable the feature, all the records that were deleted before are lost, and cannot be restored (unless you have a database backup)."}{GENERICO:type="hints_end"}

Duration: 10 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 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

i2 iBase - How to create a manual Search 360 job with the Microsoft SQL server agent

In some cases, it is not possible to create Search 360 jobs using the IBM i2 iBase Index Service Configuration Tool due to the server being in a cluster. In those circumstances a job can be created directly in Microsoft SQL Server Agent in the SQL Server Management tool.


15 minutes