Infor Expense Management Extract Transform Load (ETL) Tool

Home

Back

Forward

  • Help
  • Copy URL
  • PDF
  • Print this page

Help

Copy URL

Topic URL copied to clipboard

PDF

Print

About this guide
Introduction
Supported platforms
Defining the ETL process
ETL Content
Using ETL
Using the ETL tool
Command line parameters
Commands
Running ETL outside the ETL_Tool/bin directory
Adding or editing ADC Conversions
Configuring the ETL.xml file
Working with the language pack
Type of conversion file to use
Type of deployment script to use
Java class conversions to execute
Execute the SQL conversions
Determine the document data type to be transformed
Batch Delete Size
Delete Line Size for File
Commit frequency
SQL Batch Insert Size
Time Adjustment
Transaction Isolation Level
ETL run tracker
Full Load Table
Configuring ETL properties
Configuring conversion attributes
Writing data to an ASCII file
Reporting database migration
Running migration for SaaS customers
Running migration for On-premise customers
Scheduling ETL
Procedure for scheduling ETL with Windows AT
Procedure for scheduling ETL with UNIX Cron
Troubleshooting
Failed to lock reporting database error
DB2 connection error
DB2 path error
DB2 Setup Error
DB2 drivers mismatch error
DB2 driver problem
NoClassDefFoundError
ETL.xml not found error
Oracle Error
Project Code Troubleshooting Guide
Project Codes with non-existent parents
Duplicate Project Charge Code
MSSQL Error
Table constraint or exists error
  • Links
  • docs.infor.com
  • Send Feedback on Current Topic
  • Product Support
  • Open link in new tab
  • Open link in new window
  • Copy link to clipboard