Configuring A Unicode Text Connection

The Unicode Text Adapter allows you to process both Unicode and ANSI text files. Configure a Unicode text connection when using the Unicode Text Adapter or another adapter that supports Unicode data and that may contain Unicode data. By default, this feature is not enabled. You must select it if this DTS file is used with Unicode data.

Warning: All of the data sources in a single DTS must provide the same level of Unicode support. Creating a DTS file that inserts Unicode data into a non-Unicode data source may corrupt the target data.

TIBCO Scribe® Insight allows you to view and process both Unicode and ANSI text files when working with connections that are Unicode-compliant. For more information, see Working With Unicode Data.

  • If this DTS file uses Turbo Text mode to speed up your integration, Support Unicode data must not be selected. For more information about using Turbo Text mode, see the Performance Tab.
  • See Connecting to a Text Source for information about determining which text connection to use.

Before you begin, verify where your text files reside.

To configure a Unicode text connection

  1. In the Workbench, click View > Connections. The Connection Manager appears.
  2. Click New to begin adding a new Unicode or Unicode-compliant text connection.
  3. From the Data Sources tree, expand Adapters and double-click the Unicode Text node. The Configure — Adapter for Unicode Text dialog box appears.
  4. Click Browse. The Browse for Folder dialog box appears.
  5. Browse to the folder that contains your text data and click OK. The File Layout dialog box appears, with the following information:
  6. In Available Files, select the file you want to configure and click Configure File Layout. The Table Configuration of the File Layout dialog box appears.
  7. If you want to change the name of the table, in Table Name, enter a new name.
  8. If you want to change the delimiting character the file uses, in File Type, select the new delimiting character.

    If you select User Defined, in Delimiting Character, specify the delimiting character to use.

  9. In Text Qualifier, specify the character used to enclose text that contains spaces:

    Make sure that the text qualifier you select does not appear in your data, or the row fails.

    The most common example of this is using a single quotation (') as a text qualifier where you have data that includes apostrophes. For example LastName = "D'Arcy" or Company = "'Liza's Beautiful Blooms".

  10. Column Names in First Row — When you first open the Table Configuration tab, the columns are labeled Field1, Field2, and so on. If this table has column names, select Column Names in First Row to replace Field1, Field2, ... with the available column names (from the first row in the table).
  11. If you want the table column names to appear in the first row, select the Column Names In First Row checkbox. If this option is not selected, the columns are labeled Field1, Field2, and so on.
  12. If you want to change the period (.) separator used for decimal values, in Decimal Symbol, enter the symbol to use. For example, by default, a numeric value appears as 2345.65. If you change the Decimal Symbol to a comma, that value appears as 2345,56.
  13. If you need to change the encoding type for this file, in Default Encoding, select the appropriate type. This setting affects how ANSI files are read from or written to. For example, an ANSI file with French characters could be set to MS Windows Western European to display the characters properly.

    Note: Default encoding is an advanced feature for experienced users.

  14. Click the Field Configuration tab.
  15. If you want to change the default name assigned to the selected column, in Column Names, enter a new column name. By default, the columns are named Field1, Field2, and so on.
  16. If you need to change the type of data in the file, in Data Type, select the correct data type for the file.
  17. If you need to change the default length of text fields, in Width, enter the number of characters permitted in the field, up to 255 characters.
  18. If your data includes Date/Time fields, in Date/Time Format, you must specify a format. You can either select one of the formats from the drop-down list, or enter your own format. See Date/Time Formats for detailed information.
  19. Click OK. You return to the Configure - Adapter for Unicode Text dialog box.
  20. Click OK. You return to the Connection Settings dialog box.

    Note: Connection names can be up to 32 characters long.

See also

Advanced Connection Options

Global Connection Settings Tab

Connecting To A Text Source

Application options — Data Font Tab

Date/Time Formats With The Unicode Text Adapter

Application Options

Unicode Text Adapter Data Types

Working with Unicode Data