Hello,
I am building custom applications where I am using the same data across different application scopes.
I have a SQL database where my data is stored. I am bringing this data into a custom table I created in a custom application scope. I am thinking of this table as my "parent" or "root" table.
I then want to take this parent table, and replicate it / sync it to "child" tables located in other application scopes.
I was planning on using transform maps to accomplish this, but I am only able to select source tables which are extended from the Import Set Row table.
In SQL I would create a root table, populate the table with a stored procedure, and then create views to accomplish this. Is there something similar I can do here?
Thank you in advance.
