際際滷

際際滷Share a Scribd company logo

Introduction to data_load

S
sramkumar88

DataLoad is a tool used to load data into applications like Oracle, SAP, and JDEdwards. It reduces the time and costs of data migration by providing an easy-to-use interface for loading data. DataLoad scripts can be written to load both transactional and setup data. It allows non-technical users to load data and provides advantages over direct database interfaces. Key features include macro loading, forms playback, and built-in error handling for reliable loading of large data volumes.

1 of 10
Download to read offline
INTRODUCTION TO DATALOAD - DHEERAJ PANJWANI 1
INTRODUCTION IT IS MOST POPULAR TOOL USED FOR LOADING DATA FROM FRONT END ON FORMS OF VARIOUS ERPS & CRMS PRODUCT LIKE ORACLE APPLICATION, SAP AND JDEDWARDS. Implementing or supporting any application often requires significant effort to configure and load data, for example from legacy systems, an expensive and time- consuming activity. DataLoad reduces the time and costs associated with data migration. Its easy-to- use interface means that it can be used by non-technical employees, giving end-users an active role in the implementation and support of any system. TABLE OF CONTENTS 1. USES OF DATA LOADER.3 2. HOW TO DOWNLOAD T RI A L VERSION OF DATALOAD..4 3. EXAMPLES OF DATALOAD SCRIPT.5 4. COMMANDS USED IN DATALOAD7 5. ADVANTAGES OF USING DATALOAD.9 2
1. USES OF DATA LOADER DATALOAD LOADS DATA INTO ANY APPLICATION RUNNING IN WINDOWS, AND CONTAINS EXTRA FUNCTIONALITY FOR LOADING DATA AND SETUP INTO ORACLE APPLICATIONS. 1. Dataload help in Loading Data eg. Doing Business Transactions as well as help in Doing Replica setup for other instances or other Business units. 2. With Macro loads functionality data is loaded into forms by using keyboard and mouse. 3. Forms Playback functionality specific to Oracle Application. All versions of Oracle Forms contain 'record' and 'playback' functionality. Run Forms in record mode a file is written detailing everything you did in the forms session. Run forms in playback mode and the forms will do whatever is specified in the file being played back. So, if you enter an customer's order in your order entry system when in record mode then playback that file on another system that order will be loaded into the second system. It is very fast load i.e. 20 times faster than Macro Load and having built in error handling. 4. Can be easily used by non-technical person or end-user as Data is loaded through forms. 5. It is Front End Data Loader and thus no Direct Database Interface required. 3
2. HOW TO DOWNLOAD TRIAL VERSION OF DATALOAD Web Site: http://dataload.net There are two downloads available for DATALOAD: 1. DataLoad Classic V4.3.7.0- Freely downloaded Limitation: (a) All Features of Spreadsheet not available. (b) Forms Playback Functionality doesnt work. (c) Unable to handle error when Oracle Session disconnected. 2. DataLoad Professional V4.3.7.0 Required to Buy Recommended for users loading large volume of data and reliability is more important. Forms Playback functionality specific to Oracle Application is available in this download only. 4
3. EXAMPLES OF DATALOAD SCRIPT A. TRANSACTION RELATED EXAMPLE This Spreadsheet shows the Dataload script written to apply the Credit Memo towards invoices created in AR. 1st portion 2nd Portion 5
B. SETUP RELATED EXAMPLE - For Creating Payment Terms in AP 1st Portion 2nd Portion 6
As we run the script, the DataLoad starts loading data whether transaction or setup automatically from this form to Oracle Apps forms. 7
4. COMMANDS USED IN DATALOADER DataLoad Command Application Action(s) TAB <Tab> ENT <Enter> *UP <Up Arrow> *DN <Down Arrow> *LT <Left Arrow> *RT <Right Arrow> *SP Save & Proceed *FE Field Editor *PB Previous Block *NB Next Block *PF Previous Field *NF Next Field *PR Previous Record *NR Next Record *ER Erase Record *DR Delete Record *FR First Record *LR Last Record *SAVE Save Record *SB Send a single space character *ST Select entire field text. *SLN or *SL(N) Pause for N seconds. *BM Block Menu *AX Alt + X where X is a single letter (A-Z). *FI Find 8
*FA Find All *QE Query Enter *QR Query Run *CL Clear Field *IR Insert record *CW(window) Change to window. *ML(coordinates) Position the mouse at coordinates and press the left button. *MR(coordinates) Position the mouse at coordinates and press the right button. 9
5. ADVANTAGES OF USING DATALOAD Loading Data DataLoad is an alternative to conventional database interfaces. Loads are built very quickly. Replicating Setup Between Instances Application setup is a laborious task, often required multiple times. Use dataload to perform setup once and play back multiple times. 10

More Related Content

Introduction to data_load

  • 1. INTRODUCTION TO DATALOAD - DHEERAJ PANJWANI 1
  • 2. INTRODUCTION IT IS MOST POPULAR TOOL USED FOR LOADING DATA FROM FRONT END ON FORMS OF VARIOUS ERPS & CRMS PRODUCT LIKE ORACLE APPLICATION, SAP AND JDEDWARDS. Implementing or supporting any application often requires significant effort to configure and load data, for example from legacy systems, an expensive and time- consuming activity. DataLoad reduces the time and costs associated with data migration. Its easy-to- use interface means that it can be used by non-technical employees, giving end-users an active role in the implementation and support of any system. TABLE OF CONTENTS 1. USES OF DATA LOADER.3 2. HOW TO DOWNLOAD T RI A L VERSION OF DATALOAD..4 3. EXAMPLES OF DATALOAD SCRIPT.5 4. COMMANDS USED IN DATALOAD7 5. ADVANTAGES OF USING DATALOAD.9 2
  • 3. 1. USES OF DATA LOADER DATALOAD LOADS DATA INTO ANY APPLICATION RUNNING IN WINDOWS, AND CONTAINS EXTRA FUNCTIONALITY FOR LOADING DATA AND SETUP INTO ORACLE APPLICATIONS. 1. Dataload help in Loading Data eg. Doing Business Transactions as well as help in Doing Replica setup for other instances or other Business units. 2. With Macro loads functionality data is loaded into forms by using keyboard and mouse. 3. Forms Playback functionality specific to Oracle Application. All versions of Oracle Forms contain 'record' and 'playback' functionality. Run Forms in record mode a file is written detailing everything you did in the forms session. Run forms in playback mode and the forms will do whatever is specified in the file being played back. So, if you enter an customer's order in your order entry system when in record mode then playback that file on another system that order will be loaded into the second system. It is very fast load i.e. 20 times faster than Macro Load and having built in error handling. 4. Can be easily used by non-technical person or end-user as Data is loaded through forms. 5. It is Front End Data Loader and thus no Direct Database Interface required. 3
  • 4. 2. HOW TO DOWNLOAD TRIAL VERSION OF DATALOAD Web Site: http://dataload.net There are two downloads available for DATALOAD: 1. DataLoad Classic V4.3.7.0- Freely downloaded Limitation: (a) All Features of Spreadsheet not available. (b) Forms Playback Functionality doesnt work. (c) Unable to handle error when Oracle Session disconnected. 2. DataLoad Professional V4.3.7.0 Required to Buy Recommended for users loading large volume of data and reliability is more important. Forms Playback functionality specific to Oracle Application is available in this download only. 4
  • 5. 3. EXAMPLES OF DATALOAD SCRIPT A. TRANSACTION RELATED EXAMPLE This Spreadsheet shows the Dataload script written to apply the Credit Memo towards invoices created in AR. 1st portion 2nd Portion 5
  • 6. B. SETUP RELATED EXAMPLE - For Creating Payment Terms in AP 1st Portion 2nd Portion 6
  • 7. As we run the script, the DataLoad starts loading data whether transaction or setup automatically from this form to Oracle Apps forms. 7
  • 8. 4. COMMANDS USED IN DATALOADER DataLoad Command Application Action(s) TAB <Tab> ENT <Enter> *UP <Up Arrow> *DN <Down Arrow> *LT <Left Arrow> *RT <Right Arrow> *SP Save & Proceed *FE Field Editor *PB Previous Block *NB Next Block *PF Previous Field *NF Next Field *PR Previous Record *NR Next Record *ER Erase Record *DR Delete Record *FR First Record *LR Last Record *SAVE Save Record *SB Send a single space character *ST Select entire field text. *SLN or *SL(N) Pause for N seconds. *BM Block Menu *AX Alt + X where X is a single letter (A-Z). *FI Find 8
  • 9. *FA Find All *QE Query Enter *QR Query Run *CL Clear Field *IR Insert record *CW(window) Change to window. *ML(coordinates) Position the mouse at coordinates and press the left button. *MR(coordinates) Position the mouse at coordinates and press the right button. 9
  • 10. 5. ADVANTAGES OF USING DATALOAD Loading Data DataLoad is an alternative to conventional database interfaces. Loads are built very quickly. Replicating Setup Between Instances Application setup is a laborious task, often required multiple times. Use dataload to perform setup once and play back multiple times. 10