Solved

Automate the process to upload data from external DB

  • 5 August 2022
  • 2 replies
  • 130 views
H
Rank
Userlevel 5
Badge +13

Hi Experts,

 

There is a requirement to automate the process to upload the data from external DB(SAP) into IFS FSM DB. 

I know that we can use folder listener to achieve this requirement.

Is there a better way to achieve this than folder listener option?

 

Thanks,

Hasara

icon

Best answer by thilinaweliwita 10 August 2022, 15:41

View original

2 replies

Lee Pinchbeck
Rank
Userlevel 7
Badge +24

Hi @Hasara Dinu ,

It would entirely depend on what is being copied, how closely it matches FSM table structure, how often change would be sent and the size of each upload.

Kind regards,

Lee Pinchbeck

Currently reading: The Way of Kings - Brandon Sanderson
T
Rank
Userlevel 3
Badge +6

Hi @Hasara Dinu ,

I think T-Tables will be a better option in this case. T-tables can be used in order to import data from a table on an outside system to FSM.
Any table in FSM has related T-table starting with “T_”. The data from the external table has to be copied to the relevant t-table. 
Once data copied to T-table, it can be seen from the T-table editor.
Next, the entries in the T-table can be added to the actual table by using import functionality (perform_import_from_t_table). You might be able to create a scheduled process to import from t-table. 

You can refer to below post for more details.

https://community.ifs.com/troubleshooting-310/how-is-the-t-table-editor-used-3292

Reply


Terms & ConditionsCookie settings