Tuesday, September 19, 2017

Getting Started with Logic Apps - File Routing

The very first thing which comes in mind when starting with any Integration tool is to do couple of demo
1. How to route file from one location to another (File Routing)

In this post I intend to explore the way Logic app can be used in a scenario where only routing of files is required, also brief comparison with BizTalk File Adapter and some points to be noted.

Prerequisite:
  1. Azure subscription
  2. On Premises Data gateway (If not done already then follow -Installing and Configuring On Premises Data Gateway - By adding user to Active Directory)
Let’s start with designing the workflow:-


Create instance of Logic App
  •   Login to https://portal.Azure.com
  •   Create instance of Logic app, click on new and select Logic App
  •   Provide Name, select subscription, resource group and Location.
  •   Then select Blank Template and search for File Trigger
  •   For now there are couple of triggers available against File System
create Logic App

  •   Select the trigger type you are interested in, I have selected “when one or more files are added or modified”

  • First thing after selecting trigger is to create a connection, here we use On Premises data gateway (Connect via on-premise data gateway), thus Demo data gateway gets auto populated as it is already installed on the machine. Provide rest of the connection information.
create connection

  • After creating a connection we need to provide the Folder information, which Logic Apps needs to watch for
configure trigger

get file content action

  • Second action is to create file from the content and save it to destination folder with the same name and for that add an Action, Create File
create file action

That’s it. Logic app to route file from one folder to another folder which is on Premises is ready.




Testing


  • Created one sample xml and one text file in IN folder and both were routed to OUT folder- Logic app was triggered

Trigger successful testcase


Note: The files are not deleted from IN folder (In BizTalk file adapter deletes the files, once it drops it in messagebox)


  • Modified the already existing file in IN folder and it was routed to OUT folder - the Logic app was triggered
  • When dropped already existing sample files nothing happened - the logic app wasn’t triggered(it was skipped)

Trigger skipped testcase


Note: It seems File System trigger looks at the timestamp as well- anything older than the Interval (where it looks for new or modified files) is ignored.

If there is any other way to implement this scenario in Logic apps, then would certainly love to hear from you.

 


Related Post

 

Saturday, September 16, 2017

Check your request parameters to make sure the Path “” exists on your file system


I got this error while trying to set the input folder for File System connector Trigger in Logic apps, which is intended to trigger the Logic app which is watching a folder (with help of On premises Data gateway)


Check your request parameters to make sure the Path exists on file system



Why it happened


Before specifying the folder to watch, we need to create a connection to File System – below are the details required
 creating FileSystem connection
If you see, against username I had provided only user name, whereas it is mentioned to provide Domain\Username


What to do


We need to follow the instruction  😊 , provide the username in correct format. Specify the domain along with the username  (Domain\Username).

In my case, am connecting to folder which is Virtual Machine and it is not part of any domain, then in this scenario the Machine Name becomes the domain.
providing domain name
                                                                

After correcting the mistake, I was able to see the folders under the Root folder
Folders visible under Root folder

Friday, September 15, 2017

List of companies in Pune having BizTalk Practice

Below are the list of companies in Pune which has Projects/Practice around BizTalk Server or are using BizTalk Server, if I have missed any then please feel free to add in comments


Sr.No
Company Name
Address
Website
1.
KPIT Technologies
Hinjewadi
https://www.kpit.com/
2.
Allscripts Healthcare Solutions Inc
Kharadi
http://as.allscripts.com/
3.
TomTom
Yerawada
https://www.tomtom.com/en_in/
4.
Alliance Group Services
Magarpatta

5
Vodafone
Hadapsar

6
Tieto
Kharadi
https://www.tieto.com/
7
Emtec Technologies
Erandawane
https://www.emtecinc.com/
8
Infosys
Hinjewadi
https://www.infosys.com/
9
Atos
Hinjewadi
https://atos.net/en/
10
Capgemini
Magarpatta
https://www.capgemini.com/
11
MindTree
Hinjewadi
https://www.mindtree.com/
12
TechMahindra
Sharda Centre,Karve Road
https://www.techmahindra.com/
13
iGate


14
Zensar Technologies
Kharadi
http://www.zensar.com/
15
Wipro
Hinjewadi
http://www.wipro.com/india/
16
Syntel
Talawade
https://www.syntelinc.com/
17
MindWorx
Balewadi
http://www.mindworxsoftware.com/
18
L&T
Hinjewadi
https://www.lntinfotech.com/
19
Speheregen
Baner
http://www.spheregen.com/
20
Qeros
Baner
http://qeros.com/
21
Hitachi Consulting
Kasba Peth
https://www.hitachiconsulting.com/
22
Mphasis
Hadapsar
https://www.mphasis.com/
23
Cognizant
Hinjewadi
https://www.cognizant.com/
24
Tata Technologies
Hinjewadi
https://www.tatatechnologies.com/in/
25
TCS
Hinjewadi
https://www.tcs.com/
26
Nuance Communication
Yerawad
https://www.nuance.com/
27
EPAM
Magarpatta
https://www.epam.com/
28
Xoriant Solutions
Baner
http://www.xoriant.com/
29
SA Technologies
Kharadi
http://satincorp.com/
30
ISYX Technologies
Viman Nagar
http://www.isyxtech.com/
31
Fidelity (Formerly Sungard)
Aundh
https://www.fidelity.com/
32
Nihilent Technologies
Weikfield IT Citi Infopark
http://www.nihilent.com/
33
Harman
Magarpatta/Hinjewadi
http://www.harman.com/
34
iLink Systems    
Kharadi
https://www.ilink-systems.com/
35
i-Source Infosystems Pvt. Ltd  
ShivajiNagar
http://isourceinfosystems.com/
36
Honeywell
Kharadi
https://www.honeywell.com/
37
Fulcrum Worldwide
Hijewadi
http://www.fulcrumww.com/
38
Yerawada
https://www.telekom-healthcare.in/
39
CLSA Technologies And Services Pvt Ltd
Yerawada
https://www.clsa.com/
40
Fujitsu Consulting
Talawade
http://www.fujitsu.com/in/