Hello,
Is it possible to use SQLServer Integration Services to pull data from BPMOnline? I tried setting up a connection via the odata connection in SSIS but the connection fails. Screenshot below. Any suggestions to resolve this are highly appreciated. Thank you.
Like
Dear Allen,
The error "401 Unauthorized" usually indicates, that credentials you have inserted are invalid.
Please try to run the following URL in the browser, where Supervisor:Supervisor are your login and password:
https://Supervisor:Supervisor@026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataService.svc
If it does let you in, than check the credentials.
You can also catch the request using Telerik Fiddler application and use its parameters to set up SQLServer Integration Services connection.
Regards,
Anastasia
Hello Allen,
Please try to establish connection through EntityDataService.svc. Modify the URL in the following way:
https://026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataServic…
Hope you find it helpful.
Regards,
Anastasia
Thank you for the suggestion. Unfortunately I still get a very similar error as the previous one. Screenshot attached.
Dear Allen,
The error "401 Unauthorized" usually indicates, that credentials you have inserted are invalid.
Please try to run the following URL in the browser, where Supervisor:Supervisor are your login and password:
https://Supervisor:Supervisor@026218-crm-bundle.bpmonline.com/0/ServiceModel/EntityDataService.svc
If it does let you in, than check the credentials.
You can also catch the request using Telerik Fiddler application and use its parameters to set up SQLServer Integration Services connection.
Regards,
Anastasia
I tried the Supervisor login and it did not complain about the invalid login. This time it shows a message indicating "Too many automatic redirections were attempted"
Dear Allen,
The issue is caused by distributed licenses. Supervisor user does not have a license, therefore, every time you try to login into system, it redirects you to the license manager page.
Please use your credentials of user "Allen Dsouza" in the connection settings. On the other hand, you can distribute licenses for the Supervisor user. In this case you will successfully connect under Supervisor credentials.
Regards,
Anastasia