Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 11 Next »

Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile. The project object will be passed in as the control file.

Object Type Identification

  • Files with extensions .dat, .ctl, .ldr are included regardless of location

File Extensions 

NameDescription

.dat

.ctl

.ldr

SQL*Loader is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.

Object Type Code

SQL_LDR

Attributes

Name
DescriptionDefault ValueSupported Values
SourceSOURCEObject Source Location Type

SCM

SCM
Target LocationTARGET_LOCATIONPath to where the file should be deployed.$<PROD_TOP>/bin/
Log FileLOG_FILEConfiguration file used to download/upload data.loader.log
Data FileDATA_FILESpecifies the name of the datafile containing the data to be loaded.



Execute SQL LoaderEXECUTE_LDRShould SQL Loader be executedfalse
Target File PermissionsFILE_PERMISSIONSPermissions to apply to the file after it is deployedDefaults to the project property FDEBS_FILE_PERMISSIONS

Related Project Properties

Name
DescriptionDefault Value
EBS SQL LDR Root Source DirectoryFDEBS_SQL_LDR_ROOT_SOURCE_DIRSource folder for control (ctl) files (e.g. control).sqlldr
EBS SQL LDR Root Destination DirectoryFDEBS_SQL_LDR_ROOT_DESTINATION_DIR

(Not used currently)

$<PROD_TOP>/admin/bin
EBS Data Root Destination DirectoryFDEBS_DAT_ROOT_DESTINATION_DIR

Target directory for Dat files (e.g. $XXHR_TOP/admin/import).

(Only used for full deploy projects)

$<PROD_TOP>/patch/115/import
File PermissionsFDEBS_FILE_PERMISSIONSTarget File Permission. Will be set to target file after deployment using chmod. eg: 755

Sample Build Commands 

N/A - Build commands are not supported for this type.

Sample Deploy Commands 

cp "$SOURCE_FILE" "$XXHR_TOP/bin/";
sqlldr  userid=$FDEBS_DB_USER/$FDEBS_DB_PASSWORD control="$XXHR_TOP/bin/sqlloader.ldr" log=loader.log
  • No labels