Saturday, October 29, 2022

ODI 12C - Importing flat file to ODI studio

Usecase: Here, we will see how to import a flat .csv file in ODI studio.

High level steps:

  • Under Topology, choose physical architecture >> File Technology and create new data server and new physical schema with the file location.
  • Under Topology, choose logical architecture >> File Technology and create new logical schema.
  • Under Design >> model >> create new model or use existing model >>select Technology and logical schema 
  • Under model, create new datastore >> provide resource file name >> files format 
  • Over data store >> view data
If you want to have variable file name, then create a variable in a project and use it as refresh variable and use it in the model data store resource name as #procjectcode.variablename

Detailed Steps with screenshots:

No comments:

Post a Comment

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...