Data from Anaplan to snowflake

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

Thank you.

Answers

  • @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.

  • QuinE
    edited December 2023

    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:

    1. 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
    2. Fetch your JDBC URL from your profile. It will look something like this:
      //fea11111.east-us-2.azure.snowflakecomputing.com