Processing to Data Grid

By processing directly into Data GridTM, you have the opportunity to improve your publishing speeds.

Enabling processing to Data Grid

After you install Data Grid, the only requirement for setting up your workspace to process to Data Grid is enabling both the workspace and the extracted text field in your environment.

To enable your workspace for Data Grid, perform the following steps:

Note: We recommend you only enable Data Grid for fields storing extracted text, OCR text, or translated text.

  1. Navigate to the Workspace Details tab, and then click Edit.
  2. Enable the Is Data Grid Enabled field.
    This image shows the toggle control to enable data grid within a workspace
  3. (Optional) Next to Data Grid File Repository, select the path for the physical location of the text files used by Data Grid. If no file repository is specified for this field, and Data Grid is enabled, Data Grid stores text in the default file repository.
    Note: If you run out of space in this repository, you can specify a new repository. Data Grid will continue to read from the old repository as well as the new repository.
  4. Click Save.

To enable the extracted text field for Data Grid, perform the following steps:

  1. Navigate to the Fields tab.
  2. Locate the extracted text field and click the Edit link next to it.
  3. Enable the Store in Data Grid field under the Advanced Settings tab.
    This image shows the toggle control to enable data grid extracted text in a workspace
    Note: If you are storing extracted text in Data Grid, the Include in Text Index field is set to No because there is no SQL text index. If you want to search using dtSearch, you must follow best practice of creating a saved search of fields you want to index.
  4. Click Save.

Note: Enabling extracted text fields for Data Grid works for new workspaces only. You can't enable Data Grid for fields that already have text in SQL. If you want to migrate fields from SQL to Data Grid, you must use the Data Grid Text Migration application.

Now that you've enabled processing to Data Grid, you can proceed to running a processing set the way you normally would.

Note: The processing engine and Data Grid no longer communicate directly with each other when you process data to Data Grid. Because of this, the Write-to-Grid phase of processing has been deprecated. Instead of writing directly to the grid, the processing engine sends data to the Import API. The Import API receives the data and looks to see whether the workspace is enabled for Data Grid. If the workspace is not Data Grid-enabled, then the Import API sends all of the data to SQL. If the workspace is Data Grid-enabled, then the Import API looks at each field to see which fields are Data Grid-enabled. If the field is Data Grid-enabled, then the Import API sends that data to Data Grid. If the field is not Data Grid-enabled, then it sends that data to SQL.