Vincent Thuilot 2 Posted January 20, 2022 Share Posted January 20, 2022 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 Link to comment Share on other sites More sharing options...
Jose Leviaguirre Posted January 24, 2022 Share Posted January 24, 2022 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 Link to comment Share on other sites More sharing options...
Vincent Thuilot 2 Posted January 25, 2022 Author Share Posted January 25, 2022 Hello Many Thanks Jose I will investigate this! Link to comment Share on other sites More sharing options...
Jose Leviaguirre Posted February 25, 2022 Share Posted February 25, 2022 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. Link to comment Share on other sites More sharing options...
Vincent Thuilot 2 Posted February 28, 2022 Author Share Posted February 28, 2022 This is great to hear Jos Many thanks for the detailed description on how to implement this, it will be useful! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now