Set Up Connections
FlexNet Manager Suite
2024 R1
(On-Premises)
To gather IBM PVU consumption data from ILMT, FlexNet Manager Suite must make a direct connection to the database used for ILMT. This connection is made by an inventory beacon, which imports the necessary data, and uploads the file to the central application server for processing and display.
To configure a connection to ILMT:
- Move to the appropriate inventory beacon, and using a local account with adequate privileges on the inventory beacon server, open the Windows start menu, right-click Inventory Beacon, and select Run as administrator.
-
If you do not already have a convenient schedule for connecting to ILMT, set
the schedule first (so it is easier to link to it later).
- From the Data collection group in the navigation bar, choose Scheduling, and click New....
- Make the unique Schedule name distinguishable within the first few characters (for use in narrow display columns).
- Typically, select the radio button for daily data collection, and set the preferred time for the connection (this is local time on the inventory beacon).
- Click OK to add this schedule to the list on the Scheduling page.
-
Set up the connection from the inventory beacon to your ILMT
database.
ILMT supports either a Db2 database or a Microsoft SQL Server database. Choose the connection type to match your configuration:
Using a Db2 database:
- Select the Inventory systems tab in the FlexNet Beacon interface.
- Below the list of connections, click the down arrow on the right of the New split button, and choose Other.
- Give the connection a useful name that makes sense in listings of several connections, and for Source type, choose ILMT.
-
Set up the Connection String similarly to the
following (but all in one line):
whereProvider=driverCode.Db2COPY1;Password=password; Persist Security Info=True;User ID=db2admin; Data Source=TLMA;Location=servername:50000; Extended Properties=""
- The
Provider
value consists of:- A fixed string literal determined by the driver (for example,
IBMDADB2
using the IBM driver, orDB2OLEDB
using the Microsoft driver) - A period (separator)
- The database copy registered name (typically
TEMADB
).
Note: Including the database copy name may be optional after DB2 Version 9.7 Fix Pack 8 is applied, but its use resolves an earlier problem with accessing DB2. - A fixed string literal determined by the driver (for example,
Password
is the password that the inventory beacon should use when accessing the DB2 databaseUser ID
is the account name that the inventory beacon should use when accessing the DB2 database (DATAACCESS
privileges are required, since later versions of ILMT drop and recreate database tables)Location
includes the name of the server running the database, and the access port (typically 50000, unless locally reconfigured).
- The
Using a Microsoft SQL Server database
- Select the Inventory systems tab in the FlexNet Beacon interface.
- Click New. (If you clicked the down arrow on the split button to reveal all the options, choose SQL Server.)
- Give the connection a useful name that makes sense in listings of several connections, and for Source type, choose ILMT SQL.
-
In the Server field, identify the database host
server:
- Use either the host name or FQDN, or an IPv4 address
- If the database is on this same inventory beacon server, use the special value (localhost) including the parentheses.
- If the database instance you need is not
the default one on the server you identify, add the instance
name, separated with a backslash character. Example:
(localhost)\myInstance
-
Specify the Authentication details for the
database connection.
Select one of:
- Windows Authentication — Select this option to use standard Windows authentication to access the database server. The credentials of the account (on the inventory beacon) running the scheduled task for importing inventory are used to access the SQL Server database. This account must be added to an Active Directory security group that has access to the database.
- Windows (specific account) — Use the following two fields (enabled when you make this choice) to specify an account on the inventory beacon that can make a connection to the SQL database.
- SQL Authentication — Use the following two fields to specify an account and password registered as a user with database access on SQL Server . This account is used to access the database, regardless of the local account running the scheduled task on the inventory beacon server.
Tip: The account used needs read-only privileges. -
Identify the Database name as
TEMADB.
When you entered the Server details earlier, the inventory beacon attempted to connect and identify all databases present there. If this was successful, you can pull down the list and select the TEMADB database. If the appropriate database name is not available, you can enter TEMADB directly in this field.Tip: A default implementation of ILMT on SQL Server may offer two different databases. Because you are using ILMT (or else BigFix Inventory), choose the database called TEMADB. (The alternative database, called BFEnterprise, is for use with a different connector type, and in any case is not recommended because the combination returns very incomplete inventory.)
-
If necessary, configure the Overlapping Inventory
Filter.
This filter has effect even when you have declared that this connection to ILMT is to be your primary inventory source. In normal operation, to ensure that details imported from ILMT cannot be blocked by overlapping inventory from another source, select Import the inventory from this source for possible merging.
- Use the Test connection button to validate the details provided and ensure that the connection can operate (if not, correct the problem before proceeding), and then click Save to add this connection to your list.
- Select your new connection from the list, and click Schedule... (below the list).
- In the Select schedule dialog, choose the appropriate schedule, and click OK. The Next run column shows the projected run time for the connection.
- At the bottom of the panel, click Save to store your connection details and schedule.
FlexNet Manager Suite (On-Premises)
2024 R1