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 standard edition to use a local Microsoft SQL Server database instead.

Before you begin

Choosing a SQL Server database in place of the embedded one enables you to inspect its contents directly. TextChart supports SQL Server 2014 and later, including the Express edition.

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

To run the application after installation, you can start it 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.

    Note: For the standard edition of TextChart, the host must be the same workstation that TextChart and Analyst's Notebook are installed on.

  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.

Note: After you change the configuration to use a different database from the one you've been using, you might need to re-create your collections and reprocess the documents they contained.