Using IBM i2 iBase

Welcome to the IBM® i2® iBase documentation, where you can find information about how to use IBM i2 iBase.

Overview of IBM i2 iBase
IBM® i2® iBase provides powerful solutions for configuring, capturing, controlling, analyzing and displaying complex information and relationships in link and entity data. iBase is both a database application and a modeling and analysis tool.
Introduction
Entering records
A record is a discrete collection of information about a real world object (an entity) or the relationships between real world objects (a link). You can add records directly, or use a datasheet to target the information that you are adding towards a specific purpose.
Importing data
You can import data from iBase databases, other databases, excel spreadsheets, or text files. Before you can import any data, you define how the source data is to be interpreted during the import in an import specification. You can run the import specifications singly or in a batch (if you first set up an import batch specification).
Listing and browsing
Many tasks require you to work through a list of entity or link records. You can select one or more records, right-click them and select further options from a menu.
Sets
A set is a user-specified collection of records, possibly of different entity and link types. Entities and links can belong to more than one set, you can use Set Membership to find out which sets a record belongs to.
Finding, checking, and searching records
You can find individual records, or groups of records, for adding to or editing the information in your database or to analyze data for a particular task. There are a number of ways that you can find records, and each is designed for a particular type of inquiry.
Querying your data
You can use queries to run simple or complex searches on your database and display the results. A query is more powerful than a find in that you can locate several entities at the same time by using a much larger range of conditions.
Alerting
You can monitor records to detect when an item of interest changes or is viewed by someone else. To monitor items of interest, you add alert definitions to records (single or multiple) and to queries. When a change is detected, an alert is raised. On receiving an alert, you can drill down into the detail to find out what changed, who viewed the record, or mark the alert for follow up later.
Reporting
Reporting collates the significant data in a database. The report can either be printed, copied to the clipboard, or output as a file.
Exporting
You might need to share data from your iBase database with others. You can export entity and link records, in a format that meets the requirements of the target application.
Removing
Depending on your permissions as a user, you can remove entities and links from the database either individually or in batches. When you delete an entity, you also delete all links to that entity but you do not delete the link end entities. Deleting records is a permanent and irreversible operation unless soft delete is enabled for your database.
Working with databases
Working with other applications
In addition to the standard features that are present within iBase, integrating with other IBM i2 products can be used to reveal relationships, patterns and trends within the data.
Configuring the iBase Environment

Getting started

Overview of IBM i2 iBase

IBM i2 iBase Release Notes

Common tasks

Creating a database

Opening a database

Entering and editing data

Troubleshooting and support

IBM Software Support home page

More information

IBM Security Learning Academy

© Copyright IBM Corporation 1991, 2020.