Hi,
I've been researching this and could not get a definitive answer from either here or the Infomatica forums. Can Hyper connect read from on-prem SQL tables, import into Anaplan, and write back to on-prem tables in a SQL database?
@CommunityMember115525
HyperConnect is a native Anaplan connector so it only works to import, export data to/from Anaplan respectively. (It also runs processes and actions as part of those processes too).
At the risk of being presumptuous, I'm going to re-frame the question as to whether your use case is possible using Informatica. In which case, the answer is yes. You will only use HyperConnect to make the interface to/from Anaplan. The rest is just ETL work that can be done using normal Informatica functionality.
Let me know if I understood the question correctly.
Hi Jared,
Thank you for your response. Yes, Hyperconnect is basically Informatica in the Cloud with Anaplan connectors. As a typical ETL tool would work this way, I just wasn't sure if there were any limitations to the Anaplan Connectors...that if it had issues with reading and writing to tables. So if not, thank you for confirming that Hyperconnect allows Informatica to communicate roundtrip to SQL databases.
-Danny
Hello folks, Does anyone know how to work around the Polaris limitation of using the Formula or Ratio summary method alongside the Closing Balance within the same line item? I have a Business Unit list where the total (All BUs) must display the Corporate (1 of 20 leaf items under All BUs total) number of Unique Customers.…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
