Data Integration From Sharepoint

Great question.

It all comes down to the email address you use for your authentication. This same address must have access to the SharePoint site or your P drive.

If you use basic authentication (user ID and password) your email ID will need network access as well.

From there you can use a variety of integration methods: anaplan connect, one of the native connectors in an ETL tool like Informatica, Dell Boomi, or Mulesoft, APIs, or manually.

Long term, this is not a recommended strategy though for data integration as passwords change, ensuring your pwd is encrypted, etc...

Long term, the best approach is to use a CA certificate. There's lots of documentation on the site here that will help you with that.

Thank you Jared for the details. I tried testing Anaplan Connect from P:/drive.

As part of test, I have unzipped the Anaplan Connect 1.4.3 setup folder on P Drive and created a sample Bat script to trigger an Import action but script failed because SSO is enabled on workspace.

2020-01-31 20:45:33 ERROR [c.a.client.Program :654 ] 198792 |-- Anaplan API: Basic Authentication failed! (Feign: status 401 reading AnaplanAuthenticationAPI#authenticateBasic(String); content:
{"status":"FAILURE_BAD_CREDENTIAL","statusMessage":"Authentication Failure.

Can you please point me to a documentation which tells how to create a bat script if SSO is enabled and what parameters are necessary to pass?

Regards

Rajuvendra

https://community.anaplan.com/t5/Anaplan-Platform-Discussions/Anaplan-REST-API-with-Cert-Access-Connect-to-different-Models/m-p/57215#M9585

You may not like the answer but you can't use SSO to authenticate. You'll have to temporarily turn that off.

Read this post - scroll down to @Stacey_Gibbens comment.

You're definitely not alone. You can also upvote these ideas:

https://community.anaplan.com/t5/Idea-Exchange/Ability-to-authenticate-as-an-SSO-user-with-Anaplan-connect/idi-p/47395

https://community.anaplan.com/t5/Idea-Exchange/Allow-SSO-Users-to-run-cross-Workspaces-Imports-with-Anaplan/idi-p/38373

@JaredDolich

Thank you for the details.

When you say SSO needs to be turn off. Is it like an exception ID which we can create and do not provide "Single Sign On" access from USERS settings in model?

Can we use "sample_basic_auth_import" sample script (Anaplan conect setup example script) to connect post above user settings and trigger any action in sample model ?

I tried above steps but somehow still getting the authentication error message.

Regards

Rajuvendra

You'll need to be a workspace admin (WA) to to this but my best suggestion would be:

1. Open up the model that you're trying to import data into

2. Go to users tab

3. On that first tab that lists all the users you should see a column with SSO as a Boolean

4. For only the email that you are using to import data, you will need to temporarily uncheck SSO

5. Then you will be able to use basic authentication assuming that email ID has import permission (best to set this as a WA)

You cannot enable or disable SSO from outside of Anaplan. Well, at least not that I'm aware of.

I will sometimes use Postman or Python to test the permissions of an email ID (assuming I have a password or certificate on that email). Something you can try too before running the Anaplan Connect script. I will usually just see what import actions that email ID has permissions to run.

@JaredDolich

I have followed the exact same steps as you have mentioned earlier and using the Import batch script which comes with setup for basic authentication.But somehow still getting below error:

2020-02-03 23:59:42 ERROR [c.a.client.Program :654 ] 105992 |-- Anaplan API: Basic Authentication failed! (Feign: status 401 reading AnaplanAuthenticationAPI#authenticateBasic(String); content:

{"status":"FAILURE_BAD_CREDENTIAL","statusMessage":"Authentication Failure. If you're unsuccessful after multiple attempts, your account may be locked. If you are using the Anaplan login page, click the 'Forgot Password' link. Otherwise, contact your Anaplan administrator or Anaplan Support."})

My model role is "Full Access" and I am a Workspace Admin.

I am using below mentioned default parameter present in script, do I need to change them?

set ServiceUrl="https://api.anaplan.com"
set AuthUrl="https://auth.anaplan.com"

Regards

Rajuvendra

Let's try a few things.

1. Can you provide a screenshot of the script you're running (remove or mask out any userIDs, passwords, workspace, model, and action identifiers). We'll check the syntax.

2. Do you have a Python environment? - I can send you a script that will confirm where you might be having problems.

3. If not, do you have Postman set up? I can additionally send you an example of how we can validate where the problem might be.

Lastly, just make sure you can log on with that email and password and that the SSO is unchecked for that same email you're using to import the data.

@JaredDolich

- Script Screen shot attached.

- Python/ Postman environment is not set up.

- I have unchecked SSO for my email Id in Model and I am workspace admin. But still I am able to go to Model selection page without giving my credentials (Looks like some authentication is happening automatically).

Just fyi, I am not using Normal Anaplan URL https://us1a.app.anaplan.com/frontdoor/login?service=https%3A%2F%2Fsdp.anaplan.com%2Flaunchpad%2Fnonpublic%2Ftiles%2FModelSelect.action

link to login. I am logged into customer network and there is active directory setup to launch any application and Anaplan application is one of them. It directly takes me to Model Selection page.

Script_59211.JPG