Changing the local database

By default, the standard edition of i2 TextChart uses its embedded database for storing the information that it generates during analysis. Optionally, you can configure TextChart to use a local Microsoft SQL Server database instead.

Before you begin

To configure TextChart to use a local database, you use the TextChart Text Analytics Configuration application, which you also used to provide TextChart with a license key during installation.

After installation, you can start the application from the Windows Start menu, or by launching the executable at C:\Program Files\TextChart\RosokaConfiguration.exe.

Procedure

Assuming that you have already set up a SQL Server database for TextChart to use, the procedure for connecting to it is as follows.

Note: If you want to create a database account for TextChart to use, or to change the port on which SQL Server accepts connections, see the instructions in Database configuration.

  1. On the Local DB tab of the TextChart Text Analytics Configuration application, select your database from the Type drop-down, and ensure that the Host and Port details are correct.

  2. In the Authentication fields, provide the user name and password of a database account with administrator privileges.


    Local database configuration dialog
  3. Click Test to verify that the information you provided is correct. If the test is successful, click Save.

    Note: If you see the "Driver not Present" error message, you need to add the appropriate JAR file to the C:\Program Files\TextChart\Drivers directory, relaunch the configuration application, and try again.

    Drivers for Microsoft databases are included, drivers for MySQL are available from the MySQL website, and drivers for Db2 are available as part of your Db2 installation.

What to do next

If you need to change the configuration of the local database after you've begun to use i2 TextChart, you must close Analyst's Notebook and ensure that the TextChart application is no longer running before repeating the above procedure.