Forum Discussion
Dataflow can't use multiple connection
Hi Ankit,
I got the solution, the issue occur when I tried to merge the sharepoint table (JSD) with the SQL table (Dim Employee) which come from Gateway, so it seem like bug of dataflow will try to use connection of sharepoit to the SQL table that I merge.So when I delete the merge step and let keep to table seperate and save&clode it will auto fetching data (refresh) with successfully and then you may come back to edit flow and merge between 2 of them again so the second time will work.
The problem will occur everytime when add new different connection and not yet save but merge it to other source then it will have problem on connection, so the only way is that to make sure everytime adding new source we do save it and refresh it first, then come back edit for merging step later it will not fail.
Hi! Anonymous
I had a similar issue with my client and they were 1st connecting to Oracle and then 2nd to SP. It worked for them but vice-versa was causing issues similar to yours. I think it could be a known issue at MS, we also have a ticket with MS advise you to do the same.
Hi Ankit,
I got the solution, the issue occur when I tried to merge the sharepoint table (JSD) with the SQL table (Dim Employee) which come from Gateway, so it seem like bug of dataflow will try to use connection of sharepoit to the SQL table that I merge.So when I delete the merge step and let keep to table seperate and save&clode it will auto fetching data (refresh) with successfully and then you may come back to edit flow and merge between 2 of them again so the second time will work.
The problem will occur everytime when add new different connection and not yet save but merge it to other source then it will have problem on connection, so the only way is that to make sure everytime adding new source we do save it and refresh it first, then come back edit for merging step later it will not fail.