IBM i2 iBase
IBM i2 iBase Courses:
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 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
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
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
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
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
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
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
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.
- 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
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
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.
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.
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.
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.
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.
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.
This video will explain how to use one new feature of IBM i2 iBase 9.
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.
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.
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.
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.
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
- 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.
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.
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.
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
- Pick Lists
- Improved Form Reset capability
- Set Combine and Analyze Improvements
- FIPS Compliance
- 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
- Understand how to place entities on an ESRI Map
- Know how resolve an issue if the entity does not appear on the map
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