Hi all what's the best solution for moving data from anaplan to snowflake?
Thank you.
@GAPER,
I can't say what's best, but Snaplogic has multiple snaps to connect Anaplan with Snowflake.
I have also seen solutions where Cloudworks has been used to move data from Anaplan to AWS S3/Azure Blob/Google BigQuery and then Snowflake has been reading data in from there. This has seemed quite handy also.
Hi @GAPER - I suggest using Anaplan Connect 4.2.1 with the Snowflake JDBC driver. I have it setup, and it works very well for bi-directional integration with Snowflake. To get going quickly with Anaplan Connect, check out this article:
One thing that I did find with the Snowflake JDBC driver is that I had to use JRE 1.8. This is still a perfectly acceptable JRE and supports all the latest security features. Also, here are a couple of additional hints:
jdbc.username=snowflake_user_name
jdbc.password=snowflake_password
//fea11111.east-us-2.azure.snowflakecomputing.com
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
A while back, I shared a pattern for extracting and reporting on Anaplan audit data using a Python project hosted on GitHub. I wrote that during my time on the Operational Excellence Group (OEG) at Anaplan. The Python solution still works, and plenty of teams are running it today. The problem it solves hasn't changed:…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
