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
Hi everyone 👋 If you build or maintain Anaplan models, you've probably hit the same walls I kept hitting. Some basic questions about a model's structure have no single screen to answer them. You end up clicking through modules and pages one by one, or writing API scripts just to get a list. These were the gaps that…
Hi Everyone, We have a requirement in Anaplan Consolidation & Reporting (Fluence) where the Entity Structure needs to change effective January 2026. The key requirement is that the existing entity structure should continue to be applicable for all reporting and consolidation periods through December 2025, while the new…
We've been building a tool called aplan4sheets and we'd genuinely like input from this community — both on what we've built so far and on what we should prioritize next. The problem we set out to solve: Anaplan's Excel add-in is Windows-centric, and there's no real native way to pivot Anaplan data in Google Sheets. We…
