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
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
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.…
