Hi All,
We are trying to build a model which would contain forecasting results flowing from Python. Please direct me to the best learning material from where I can work on this integration of Python / R with Anaplan
Thanks and regards,
Aishwarya
Hi Aishwarya,
Once you write data into a csv or txt file from Python or R, then you can easily import data into Anaplan.
You might want a direct integration into Anaplan, but i would stress that much can be learned from this MVP (minimum viable product), i.e.
1. Are we importing at the right granularity?
2. Is the header name constant?
3. Is the data format constant?
etc etc
Having said that, what do you think? @jesse_wilson
Thanks,
LipChean
Hi,Please refer to the Python library in our knowledge base. This covers all API functionality and saves you the time developing from scratch. Simply use the "steaming" upload functionality, this allows you to write data from memory to Anaplan. Please note, that you will have to handle the chunking of the data yourself, I couldn't come up with a elegant way to handle data chunking within this method when I wrote the library. If your data is anything under 50mb there's no problem, but anything over this and you will need to split the data up into smaller segments.Regards
Thank you so much @jesse_wilson and @LipChean_Soh !
We shall check what works best for us and communicate once successful
Hi,
@jesse_wilson
We tried implementing the Python library in knowledge base. We need to install the Modules Requests and M2Crypto to use this library. But we are unable to figure out how the modules with downloaded files work with the library. Also, we need more technical clarification on how the Java keystore script works. In addition to the above, please help us to find the private key for certificate authentication.
Jamuthira R
In order to download those modules, you simply need to use the pip (or pip3 depending which version of Python you're using) utility to fetch them. To obtain a keypair (public and private key), please review our article that discusses this topic in depth.
Once you've procured the certificate, you need to extract the public and private keys and edit per the above article, rebuild the p12 file, then create a Java keystore from this.
openssl pkcs12 -export -in <CERTIFICATE.pem> -inkey <PRIVATE_ KEY.pem> -out keystore_bundle.p12 -name
<KEYSTORE_ALIAS> -CAfile <CERTIFICATE.pem> -caname root
keytool -importkeystore -deststorepass <KEYSTORE-PASSWORD> - destkeystore my_keystore.jks
-srckeystore keystore_bundle.p12 -srcstoretype PKCS12
Please note that the password you set for the private key, the p12 bundle, and the keystore must all be the same or the library won't be able to read the private key from the keystore.
Thanks
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
Hi all, I, as an Anaplan workspace administrator, am working together with a Fabric team to export data from Anaplan to Fabric via Anaplan API and Postman. We have a problem where all Anaplan exports are visible in Postman but when trying to connect to SOME of them, we get message "404, Not found". Below screenshot showing…
