File retrieval from FTP to servicenow and creating record in servicenow

[Sriniwas]

Hi,

I have a requirement to retrieve the file from FTP server to servicenow and then create record in servicenow.

As per process,

1)we can create the data source with type FTP and provide the username and password and path where the file located.

2)create the transform map with import set table and load the data to target table.

can anyone please help me with below questions:

1)what is the difference if we use MID server and with out MID server for this requirement.

2)if i have so many folders in FTP (for example more than 50 folders and each folder contains one file), how to retrieve the files from all the 50 folders and load the data into servicenow.

Is one data source is enough or do we need to create 50 data sources?

Thanks,

Sriniwas

[Allen Andreas]

Hi,

MID Server for that data source of FTP doesn't matter. It's pointing to the FTP not the MID Server. If you use a MID Server, as the source, then you can do more with bulk files, etc. but it's way more complex than an FTP data source.

For the amount of sources, you'd have to set up the various data sources as it points right to the file, not a folder.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Sriniwas]

Hi Allen,

Thanks for the reply.

That means, if i have 50 files as mentioned on FTP then need to create 50 data sources?

Thanks,

Sriniwas

[Allen Andreas]

Hi,

That's correct. Trust me, initially, years ago when I first was doing data sources...I pointed right to the folder...thinking that was it and it would error out, haha.

Later, I learned that you have to point to the literal file as well.

Please mark reply as Helpful/Correct, if applicable. Thanks!

[Sriniwas]

Thanks Allen for your valuable inputs on this.

just one more last question, is there any other approach to fulfil this requirement like integration hub or something like that?

Thanks,

Sriniwas