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
Hi Anaplanners, I’m working with a calculation module (Module A) that is dimensioned by a concatenated list, Time, and Native Versions. In this module, I am performing a subtraction using values from another module (Module B), which is dimensioned by Native Versions and a different concatenated list. The two concatenated…
I am trying to create a Net Debt / EBITDA formula at the bottom of one of our P&L income statements where, i have tried the MOVINGSUM function. However this does not work for summary line items which EBITDA is. What i would like is to be able to sum the previous 12 months EBITDA (Including the current period) numbers in a…
I have a selective access cost center list in a flat format that contains multiple hierarchy levels. I need to assign more than one cost center parent to a single user. While this can be done manually, I would like to know if there is a way to import this through a CSV file instead. Could you please confirm if this is…
