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
I am trying upload data from a CSV with date. For size reasons, I don't want to dimension the module by date but bring it in as a line item formatted as date. The problem is that person that will be doing the upload is in Italy, and their date format is different. When she does the upload, the date gets messed up…
Hi, when I am assigning the account to the territory I am always facing error as below and account never get assigned to the territory , what could be the reason ? When I use same method for unassign it works .
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:…
