This content has been marked as final. Show 3 replies
You will need to create a process that generates the data to a .txt file prior to import and then create an import format to parse the source file.
Or you can use a Integration script that pulls the data directly from the source table into the FDM Work Tables.
Can we create a process that when user clicks on import which will create a .txt file and loads into FDM by using an import formate ?
If we can create can you please let me know how we can achieve that.
There is not an out of the box method to do this. It may be possible with customizaztions, however I don't really see a way of doing this. You will most likely need to extract the data from the Database Table first and place the file in the inbox and then write your import format to parse the file and have users select the file from the inbox.1 person found this helpful
Or if you are looking for a lights out process place the file in open batch and then use the batch loader to process the files.