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