3.2 Adding a Connection Profile

After defining a project, you can create a connection profile, which provides the driver details necessary for Analyzer to communicate with the specified application data store. There are three ways to create connection profiles in your Analyzer project:

NOTE:If you need to get data from a file, such as a spreadsheet, see Section 3.3, Creating a Flat File Profile.

3.2.1 Creating a Connection Profile

To create a new connection profile from scratch:

  1. In the Project view, expand the project with which you want to work.

  2. Right-click the Connections object, then click New Connection.

  3. In the Select an Application dialog box, select the type of application for which you want the connection profile, then click Next.

    The category list organizes the many applications into similar groups. Selecting a category displays a subset of all available applications.

  4. In the Select Driver Configuration dialog box, select the XML configuration file for the selected application, then click Next.

  5. In the Name the Connection Profile dialog box, specify a name for the connection profile, then click Next.

    Optionally, you can provide a detailed profile description in the Notes field.

  6. In the Connection Settings dialog box, specify the necessary connection information to connect to the selected application, then click Next.

    The particular settings vary by application, but common settings include the Hostname (or IP address), Username, Password, and whether the driver is Local (on the machine running Analyzer) or Remote (available through Remote Loader.)

    Depending on the application, Analyzer might display more than one Connection Settings dialog box to collect the information it needs to configure the application connection.

  7. In the Summary dialog box, review the settings for the connection profile.

    • If necessary, click Add Libraries to add a third-party library (typically a .jar file) for your application. You can add these after the fact by selecting Window > Preferences and selecting Analyzer > Connections.

    • Select Create Data Set Definition to have Analyzer automatically create default data set definitions based on information provided in the connection’s preconfig settings. For more information about data set definitions, see Section 3.5, Creating a Data Set Definition.

  8. Click Finish

After creating the connection profile, you must start the driver in order to query the data store. You can do this when creating a data set that utilizes the driver, or you can right-click the connection profile in the Project View and select Start Driver.

NOTE:To use the SAP User driver, you must install the sapjco.jar library in Analyzer, and install the librfc32.dll and sapjcorfc.dll into the Windows %systemroot% folder (typically C:\windows\system32). Restart Analyzer after installing these files.

The Analyzer DB2 driver requires the db2java.zip and db2jcc.jar libraries to function properly. You can download these libraries from IBM.

3.2.2 Importing a Connection Profile Information from Designer

If your project is based on a Designer project, the information for each driver can be reused in Analyzer.

To import a connection profile based on an existing Designer project:

  1. In the Project view, expand the project with which you want to work.

  2. Right-click the Connections object, then click Import from Designer.

  3. In the Application Found dialog box, select the applications you want to import as connection profiles, then click OK.

    By default, Analyzer selects all applications for which Analyzer drivers exist. Applications for which Analyzer does not have drivers display in red.

    IMPORTANT:Analyzer supports some Designer applications only through Identity Manager’s Remote Loader. If you have such an application with a local configuration, Analyzer prevents you from importing it as a connection profile until you reconfigure the application to use Remote Loader. For more information about the Remote Loader, see the Understanding the Remote Loader in the NetIQ Identity Manager Setup Guide.

    If you have several Designer applications, click any of the column headings in the Applications Found dialog box to sort the list based on that column. Click once to sort in ascending order. Click again to sort in descending order.

  4. In the New Connection Creation dialog box, click OK.

    Analyzer lets you import the same Designer application into multiple connection profiles so you can create multiple variations for inspecting and analyzing data.

After importing a connection profile from a Designer project, you must start the driver in order to query the data store. You can do this when creating a data set that utilizes the driver, or you can right-click the connection profile in the Project View and select Start Driver.

NOTE:If the Analyzer driver won’t start, you might need to add a third-party library (typically a .jar file) for the application. You can add third-party libraries by selecting Window > Preferences > > Analyzer > Connections, then click Add to select the .jar file.

3.2.3 Importing a Connection Profile from a File

To import a connection profile from a previously exported connection profile file:

  1. In the Project view, expand the project with which you want to work.

  2. Right-click the Connections object, then click Import from file.

  3. Browse to and select the connection profile file you want to import, then click Open.

After importing a connection profile, you must start the driver in order to query the data store. You can do this when creating a data set that utilizes the driver, or you can right-click the connection profile in the Project View and select Start Driver.

NOTE:If an imported connection profile won’t start, you might need to add a third-party library (typically a .jar file) for the application. You can add third-party libraries by selecting Window > Preferences > > Analyzer > Connections, then click Add to select the .jar file.