Using File Based Loader to Extract Maximum Value
Guest post by
Prashant Sharma, Project Manager, Infosys
With the Cloud buzz picking pace, lot of organizations are moving to Software-as-a-Service (SaaS) based applications. ERP implementations that would on an average take close to a year, are now being executed in few weeks. Data conversion, as always, is one of the key activities in these implementation projects. Earlier, technical and functional teams used to spend many person months developing data conversion programs and utilities, as part of the project life cycle. This is not the case anymore with Oracle Fusion SaaS implementations. File Based Loader (FBL) is a very effective data upload tool, which guides customers in their implementation journey to Oracle Fusion applications.
How does the magic of FBL work?
FBL can be used to import data from an external system into Oracle Fusion HCM SaaS, ensuring that the data satisfies Fusion' business rules. It simplifies the entire data conversion exercise as data gets loaded using 'predefined delimited flat file(s)' for various business objects. It uses a Webservice to move the (.zip) file containing the pipe delimited data files, to stage directory via SFTP. The (.dat) files are then unzipped by a Python script. The SQL loader then reads the data from these (.dat) files and loads this data into staging tables. A dedicated work area in the user interface allows implementers to manage batches of data loads including invoking the data load, monitoring the processes as they run and reviewing and correcting errors after the loading is completed. While loading the data into Oracle Fusion tables, all business rules and validations are triggered to ensure data integrity. FBL allows multiple source systems to import data into Fusion HCM. This tool can be used for both- bulk loads, initially during the implementation phase, and for incremental loads going forward. FBL leverages PLSQL BULK/caching capabilities and delivers impressive performance.
Infosys leveraged FBL to load the entire person and work relationship data for a large and multi country retailer in the Middle East region for Oracle Talent Cloud Implementation, making it the first Oracle Fusion HCM Implementation project worldwide to go-live using the File Based Loader. Infosys has also developed a seamless and complete co-existence solution for Oracle Fusion Cloud and On-Premise Oracle Applications Unlimited, like PeopleSoft and EBS, as demonstrated in the image below.
Note: I thank Upendra Raja Rao (Principal Consultant, Infosys) for providing inputs for this blog.