Hello Friends!!
So here is the requirement, using ODI we need to create interfaces for transferring data from file ( in one location) to file ( to another location).
You might be thinking we can directly put the files from one location to another using any of the secure copy command from Unix, but think it this way: The files come to the desired location as everyday job, our scheduled ODI jobs will pick the files and put them to another location ( how easy is that).
Now the constraint is, I am not provided with any of the RDBMS from the client to run my mappings in between and if I have to run ODI I need at least one RDBMS area for processing.
What to do now?
In a situation like this, “Sunopsis Memory Engine” Can help us
Actually Sunopsis Memory Engine is an In memory pure java based RDBMS. (hsql).
So our problem is solved now, we can utilise this as the RDBMS area for processing, so now when you create the interface where the source and target data store are both of File type, check the checkbox “Staging area different from target” and select the Sunopsis Memory Engine.
In the flow tab select the KMS:
LKM: File to SQL
IKM: SQL to File Append.
Save the interface and Execute it…….
Bingo!!! the file is generated at the other server.
So here is the requirement, using ODI we need to create interfaces for transferring data from file ( in one location) to file ( to another location).
You might be thinking we can directly put the files from one location to another using any of the secure copy command from Unix, but think it this way: The files come to the desired location as everyday job, our scheduled ODI jobs will pick the files and put them to another location ( how easy is that).
Now the constraint is, I am not provided with any of the RDBMS from the client to run my mappings in between and if I have to run ODI I need at least one RDBMS area for processing.
What to do now?
In a situation like this, “Sunopsis Memory Engine” Can help us
Actually Sunopsis Memory Engine is an In memory pure java based RDBMS. (hsql).
So our problem is solved now, we can utilise this as the RDBMS area for processing, so now when you create the interface where the source and target data store are both of File type, check the checkbox “Staging area different from target” and select the Sunopsis Memory Engine.
In the flow tab select the KMS:
LKM: File to SQL
IKM: SQL to File Append.
Bingo!!! the file is generated at the other server.
