Importing Anaplan Data

[Vincent Thuilot 2]

Hello,

Could someone explain how we can import Anaplan data into Spotfire Is there a specific connector that I should install

I heard there is a Auth 2 connection, but I have a very basic level in all this. Don;t know how to handle this.

Something that explains step-by-step how to make it happen would be awesome.

Thanks for your support!

Vincent

[Jose Leviaguirre]

It looks like Anaplan supports JDBC drives. With this JDBC drivers you can ask you Spotfire admin to crete an information link and add the JDBC driver to the.tomcatcustom-ext directory.

Anaplan also supports ODBC so if you want to connect only your client, you can do so with ODBC. Here are step by step guide I found from Anaplan.

 

https://s3.amazonaws.com/anaplanenablement/Community/Anapedia/Anaplan_Co...

Once you have the drivers and everything you need for a sucessful ODBC connection, then you can use Spotfire as many other software to bring the data from it.

I ecommend however, using TDV (Tibco Data Virtualization) wich is part of Spotfire to get data on-demand and perform dynamic queries through its connector vs bringing all data at once on memory via ODBC in you are dealing with large amounts of data

[Vincent Thuilot 2]

Hello

Many Thanks Jose I will investigate this!

[Jose Leviaguirre]

Hello Vincent, there is another way to bring data from any ODBC data source, but again, it is recommended to use information links or a proper connector for complex operations or large amounts of data.

[Vincent Thuilot 2]

This is great to hear Jos

Many thanks for the detailed description on how to implement this, it will be useful!