User Guide > Map Connectors > Source and Target Map Connectors > Oracle SQL Loader
Was this helpful?
Oracle SQL Loader
An Oracle SQL Loader file is a special format to which the integration platform can write using the Oracle SQL Loader connector. This file can be imported into Oracle quickly using the Oracle SQL Loader utility.
Although the Oracle SQL Loader appears as a source connector in the integration platform, its purpose is to read and verifying loader files that the platform has created when the application is not available.
This connector produces the flat loader files that can be uploaded into an Oracle database. It is not necessary to have Oracle client installed and configured on your system to connect to this connector with the integration platform.
This connector sets field width in bytes. What actually varies is the number of characters that fit into a given field. For example, if a field width is 10 bytes and the encoding is Shift-JIS, the field can hold a minimum of 5 characters and a maximum of 10. This means that if you try to write 8 Japanese characters, data is truncated (the Kanji characters all take 2 bytes).
Connector-Specific Notes
DateValMask: The integration platform does not support milliseconds in DateValMask transformations. Although a mask is provided for them, the integration returns zeros in those places.
Unicode Support: The Oracle SQL Loader connector does not have Unicode support. For Unicode support, use the ODBC 3.5 connector. To have double-byte support in Oracle connectors, change Regional and Language Options on your system to a double-byte language, such as Japanese.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target. The fields that are available depend on the connector you select.
For a list of all parts for source connectors, see Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Target Connector, Parts, and Properties.
Property Options
You can specify the following source (S) and target (T) properties:
Property
S/T
Description
BadFile
T
Name of the file to which rejected records are written when running the Oracle Loader utility. If you leave value blank, the default file name is tabname.BAD. To change the default name, type a new one in the Value field.
CodePage
S/T
Encoding to use for reading and writing data. The default is ANSI, the standard in the US.
CommitRows
T
Number of records the Oracle Loader reads before doing a Commit. Default is 50. To change the default, type a new number in the Value field.
DelimitAllFields
T
Default is false. If set to true, the integration platform inserts delimiters around all text fields.
Direct
T
Specifies whether or not to write out the control file that includes the Direct option. Default is false.
DiscFile
T
Name of the file to which discarded records are written when running the Oracle Loader utility. Default file name is tabname.DSC. To change the default, type a different name in the Value field.
DiscMax
T
Maximum number of discarded records. The default is 50.
DoublBackSlash
T
Whether or not to write double backslashes (\\) to the Oracle SQL Loader file name. Default is false.
Errors
T
Maximum number of rejected records. Default is 50.
Load
T
Maximum number of records to load into the table. Default is zero, which means to load all records. To change the default, type a different number in the Value field.
LoadOpt
T
Type of load operation to use after the SQL Loader file has been created. Options are insert, append, and replace. Default is insert.
NullCols
T
Whether or not to write out trailing null columns. The default is true.
Skip
T
Whether or not the Oracle Bulk Loader utility skips a number of records before starting the load. Default is zero, which means that loading starts with the first record. To change the default, type a different number in the Value field.
StripLeadingBlanks
S/T
Whether or not to strip leading blanks from data fields.
• When Oracle SQL Loader is the source connector, leading blanks are not stripped from the data. To remove them, set StripLeadingBlanks to true.
• When Oracle SQL Loader is the target connector, leading blanks are stripped when the data is written. To remove them, set StripLeadingBlanks to false.
StripTrailingBlanks
S/T
Whether or not to strip trailing blanks from data fields.
• When Oracle SQL Loader is the source connector, trailing blanks are not stripped from the data. To remove them, set StripTrailingBlanks to true.
• When Oracle SQL Loader is the target connector, trailing blanks are stripped when it writes data. To remove them, set StripTrailingBlanks to false.
TableName
T
Name of the Oracle database table to which data is written. No default.
Supported Data Types
The following data types are supported:
• Char
• Date
• Float External
• Integer External
Last modified date: 07/26/2024