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
Can someone help me i am unable to login anaplan portal using my credentials
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…