I want to achieve below requirements using Workfront Fusion.
Does anyone have any pointers or suggestions for this?
I think you need to be very careful doing this setup as there are multiple solutions "flying around".
We are currently in the middle of setting this whole thing up together with Adobe Professional Services.
If you are working with Experience Manager Assets as a Cloud Service and your Workfront instance is already migrated to the Adobe Admin Console, the statement is that the enhanced connector is deprecated. They told us to use the so called native connector which you can find under Setup -> Documents -> Experience Manager Assets.
Unfortunately this native connector currently seems to be in a very early stage in comparison with the enhanced connector.
Just today I had a longer call with a Workfront expert who confirmed that we need to use Adobe Workfront Fusion to achieve some of the missing functionality expected by us. Fortunately we already have a Fusion instance although it could also be achieved talking to the APIs directly, I think.
Please don't hesitate to direct message me, if you have further questions. For me it was very annoying that now several weeks have passed until I got an "official" confirmation that the combination of native connector and fusion is the only way for us. Furthermore, professional services are relatively cost-intensive.
Unfortunately until now we are not able to connect Fusion to our AEM instance as for the connection it is necessary to create a so called "Technical support user" using the Developer Console of your AEM instance (https://experienceleague.adobe.com/docs/experience-manager-cloud-service/content/implementing/develo...). We are trying to do it for almost 2 weeks, but it fails with a 504 (Bad Gateway) response. Since the first occurance, there is a support ticket running, but with no solution. I will get back to you, as soon as I made some progress.