About Shailendr

Dear Ben , Really thankyou for the advice , suggested did magic and I am able to download in required format .txt . Appreciate your great support.   Could you please Also Advice me for GL Hierarchy load Script? Actually I need to import GL Account master Data and GL Account Hierarchy . I have been provided with Single Process Name for Both Action and have also Provided with two file name for master data and for Hierarchy load.    Does the import will work with single Script or do I need to create two Separate Script ..1 for GL Master Data load and 2nd . for GL hierarchy Load?   Kindly advice on the same. Appreciate you kind guidance . Warm Regards Shailender Dubey   ... View more

Dear Mark ,   thanks for your Guidance , Now I am god to generate the Encrypted Private key from Received .pfx client certificate .   Command For Encrypted Private Key. pkcs12 -in "D:\Anaplan Integration\Certificates\XYZ.pfx" -nocerts -out "D:\Anaplan Integration\Certificates\PVTKEY.pem"   pkcs8 -inform PEM -in "D:\Anaplan Integration\Certificates\PVTKEY.pem" -outform PEM -out "D:\Anaplan Integration\Certificates\ENPVTKY.pem" -passout pass:TrwtPFZ   Now I am looking for Key store Bundle Creation for Public/Private key .Soon Update on same .   Thank you once Again for your Guidance!   Warm Regards Shail ... View more

Hi DSoomer ,   I exactly following same commands for creation of Encrypted private and Java key store bundle ,But unfortunately its not working for we  . For your Information we received Certificate in .pfx format from vendor .we did extracted public cert and Private unencrypted key.   But my challenge here is while extracting Encrypted Private key and while creation of Java key bundle I am getting with error as highlighted above. I would be highly thankful for your great advice to crack it down.   Warm Regards Shailender Dubey ... View more

Hi Mark ,   thank you for your kind favor!   I did the execution of same command shared by you but still throwing error. Seems error "pkcs8: Option unknown option - error in pkcs8" hope its not able to recognize pkcs8 . Command for Encrypted Private Key : pkcs8 -inform PEM -in "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\PRIV_KEY.pem" -outform PEM -out "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\AC_PRIV_KEY.pem" -passout pass: q2UvIFdnuzdk   Error : pkcs8: Use -help for summary. error in pkcs8 OpenSSL>   Infect I tried to Create Java Key Store Bundle but again throwing Error. Sharing Command Below for Java key store bindle.   Command For Java Key Store Bundle Creation : pkcs12 -export -in "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\Publicrt222.pem" -inkey "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\PRIV_KEY.pem" -out "D:\Anaplan Integration\Xtra\Temp Folder- to be deleted\keystore_bundle.p12" -name KEYSTORE_VIR   Error : unable to load private key 18152:error:06065064:digital envelope routines:EVP_DecryptFinal_ex:bad decrypt:crypto\evp\evp_enc.c:610: 18152:error:23077074:PKCS12 routines:PKCS12_pbe_crypt:pkcs12 cipherfinal error:crypto\pkcs12\p12_decr.c:63: 18152:error:2306A075:PKCS12 routines:PKCS12_item_decrypt_d2i:pkcs12 pbe crypt error:crypto\pkcs12\p12_decr.c:94: 18152:error:0907B00D:PEM routines:PEM_read_bio_PrivateKey:ASN1 lib:crypto\pem\pem_pkey.c:88: error in pkcs12   I would be highly thankful for your support. awaiting to hear !   warm Regard Shailender Dueby     ... View more

Dear Jared ,  Thank you for your response. I went through those Guide for CA .for your information, we have procured the Certificate from DIGICERT. But my doubt here is we have received 3 files for CA Authority. 2 .CERT and 1 file as .CER. So we are not clear with the SHA256root.cer file as well as Intermediate.crt file. unfortunately ,no where its mentioned in shared ppt. So please let us know which file we should Register/Manage with Anaplan as tenant Administrator? Also what is role of SHA256root.cer and intermediate.crt file. I would be highly thankful for your great Support.   Thanks and Regards ShailD ... View more

Dear Ben , Hope you are doing great , as per my query on whitelisting . I found ever using Proxy we are mentioning the yellow highlighted in script as shown in attachment. Does it mean even if we use Proxy we need to pass these parameter in script? Kindly Advice how to write Import script with Anaplan Connect . where we did not whitelisted the services API/AUTH. Appreciate your great favor!   Warm Regards Shailender Dubey         ... View more

Hi Jared ,    Thankyou for your kind advice . As per your Give Code snippet Can we Exclude    -service ' https://api.anaplan.com ' -auth ' https://auth.anaplan.com ' from the Script ? Since my Client is not willing to whitelist mentioned both.    Could you please advice me the work around in case we need to void( not willing to whitelist due to client security policy) these service and autho in Script for Import/Export.   I would be highly thankful to you , awaiting for your kind favor!   Warm Regards Shailender Dubey ... View more

Hi Ben ,   Kindly Share me the Dummy Script , who to pass Via statement please . Just want to to check will it work then in that way which you Suggested ?    Warm Regards Shailneder ... View more

HI Ben , Hope you are doing great! Looking for your Kind Advice .. Actually , I am working with Anaplan Connect to Import/Export files from server. Due to Security policy my client is not willing to Whitelist below both services. api.anaplan.com & auth.anaplan.com . where as they are suggesting to use proxy and port in my Script . or Data Power path Anaplan Connect -> www.XXXX.ws.ABC.com/API & www.XXXX.ws.ABC.com/AUTH -> api.anaplan.com & auth.anaplan.com - No proxy config Can we use a different url like www.XXXX.ws.ABC.com/API instead of api.anplan.com in the script. The URL www.XXXX.ws.ABC.com/API will convert to api.anaplan.com when it hits the internet. ... View more

Dear Nathan ,   Appreciate your favor , But seems security team is not willing to whitelist the Anaplan URL . Whereas they suggested in below two Approach . Kindly Advice how to proceed with below option provided by them in script? Option 1 : 1. Data Power path Anaplan Connect -> www.XXXX.ws.ABC.com/API & www.XXXX.ws.ABC.com/AUTH -> api.anaplan.com & auth.anaplan.com - No proxy config Can we use a different url like www.XXXX.ws.ABC.com/API instead of api.anplan.com in the script. The URL www.XXXX.ws.ABC.com/API will convert to api.anaplan.com when it hits the internet.   Option 2 :  Zscalar Proxy path Anaplan Connect -> api.anaplan.com & auth.anaplan.com (via zproxy.ABC.com on port XXXX) - zproxy.ABC.com   So,If we want to use api.anaplan.com and auth.anaplan.com can we mention proxy and port in the script somewhere.    Kindly Advice!   Warm Regards Shailender dubey ... View more

C:\Users\T19NMOU>echo %JRE_HOME% C:\Program Files\Java\jre1.8.0_15 ... View more

Dear Sean,   Appreciate your favor , We have already done the variable setup since we have JRE so I made JRE_HOME .for your view please see the below screen .     But still I am getting error . Kindly do let me know if I a missing another setting. ... View more

Hi Ashish , Thankyou for the valuable links !!   But seems my Query is still unanswered , Suppose My Client is having SSO enabled for me , So is it Possible for me to Work with SSO by having my CA Certificate?    Or How CA Certificate works with SSO enabled User??   Warm Regards Shailender Dubey ... View more

Hi Ashish ,   Thank you for your Support , Just last query I have is how SSO enabled is Different from Basic Authentication or you can understand my Query in this way    what is Difference in all tree Mode like SSO/Basic/CA based Authentication User. Can you please help me to understand the Differnce in all these 3 mode enabled user.   thankyou in Advance and for consistent support.    Warm Regards Shailender dubey ... View more

Dear AB ,   But as per my Understanding while scripting , we need to pass Username and password as a mendatory parameter So what kind of setting or steps we need to do in case of SSO enable Id .   Could you please elaborate me bit more on this .   Warm Regard SD ... View more

Dear , Thank you soo much for your prompt Response.   Warm Regards Shailenderdubey ... View more