Data from Anaplan to snowflake

GAPER

Hi all what's the best solution for moving data from anaplan to snowflake?

Thank you.

Accepted answers

All comments

Dikshant

@GAPER,

I can't say what's best, but Snaplogic has multiple snaps to connect Anaplan with Snowflake.

pyrypeura

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.

QuinE

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:

https://community.anaplan.com/discussion/155760/anaplan-connect-quick-start-guide-windows-installation

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:

You do not need to use public and private keys; instead, set the user name and password in the jdbc.properties file.
jdbc.username=snowflake_user_name
jdbc.password=snowflake_password
Fetch your JDBC URL from your profile. It will look something like this:
//fea11111.east-us-2.azure.snowflakecomputing.com

Quick Links

Can you help?

Unanswered questions

Hi Team , I am unable to login to the Anaplan portal using my credential.
Can someone help me i am unable to login anaplan portal using my credentials
Finding History for List Item Creation and changes
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
Action fails via cloudworks but works manually
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…