Creating a Data Source Name (DSN) in Windows

Important: To run fingerprinting or discovery tasks on Oracle, Microsoft SQL Server, or MySQL databases, the password for the account used to access the database cannot include a semi-colon (;).

A DSN is required to create a database table fingerprint or set up database discovery. If the database does not already have a DSN, create one as follows:

Steps

  1. Go to the crawler machine that is being used for fingerprinting tasks.
  2. Log in as the Forcepoint DLP administrative user.
  3. Access the system’s ODBC Data Source Administrator.
    • Windows Server 2012: Go to Start > Administrative Tools > ODBC Data Sources (32-bit) or (64-bit).
    • Windows Server 2008: Go to Start > Administrative Tools > Data Sources (ODBC).
  4. On the User DSN tab, click Add.

    User DSNs store information about how to connect to a specific data source. They may be used only by the current user on the current machine.

  5. Use the Create New Data Source dialog box to select the appropriate database driver.
  6. When prompted, enter a data source name and description. Some drivers require additional information:
    • For Excel, select a workbook and enter the number of rows to scan.
    • For Access, select the database and the page timeout.
  7. Click Advanced or Options as needed to provide details for the database records that will be fingerprinted, then click OK.
  8. If you selected a Sybase or DB2 driver:
    1. Stop all discovery tasks and fingerprinting jobs running on this machine.
    2. Open the Windows Services tool (Start > Administrative > Tools > Services).
    3. Right-click Forcepoint Data Task Scheduler and select Restart.