Running the Oracle Client on a Non-English Database

If you run the DATABridge Oracle Client on a non-English language database (for example, Portuguese, Spanish, French, German), you may run into problems with replicated data that includes decimals. DATABridge follows the U.S. standard of using a period to represent a decimal mark, unlike most European languages, which use a comma.

DATABridge Oracle Client is designed to use SQL statements that assume the database language is U.S. English. Therefore, you must make the following changes before running the DATABridge Oracle Client to ensure that these numeric values are correctly interpreted and won't result in SQL errors.

  1. Create a file called script.user.session in the scripts directory that contains the following statement. If this file already exists, add this statement to it.

    ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN' NLS_TERRITORY= 'AMERICA'

  2. Modify the Bulk Loader settings in the Client configuration.
    1. From the Client Console, right-click the data source and choose Client Configuration.
    2. From the left panel of the Client Configuration dialog box, click Bulk Loader and make the following changes:
    3. For Delimiter, enter the pipe symbol ( | ). (You can use a different symbol, provided it isn't a number, a decimal character, a comma, a plus or minus character, or a quotation mark; however, the pipe symbol tends to be most readable.)
    4. Select the check box Use comma for decimal character, and then click OK.

Note: Alternatively, you can modify the bulk loader settings by exporting the Client configuration file and editing the [bulk loader] values as follows:

Bcp_decimal_char=","

Bcp_delim=”|”

For instructions, see Appendix C: Client Configuration in the DATABridge Client Administrator's Guide.