Infor EPM V12 - ImportMaster - Exporting Hierarchy to an Excel file
I am familiar with using Excel as a data source for ImportMaster. I am now trying to export an hierarchy from ImportMaster into an Excel file, using the Hierarchy Parent/Child as source and the Excel file as destination object (Resultset).
When setting up the connection in Data Link Properties if I set the Access Permission to 'Write' I get the following error:
"Error occurred while attempting to set the properties you entered - Persist Security Info (NOT SUPPORTED)"
If I try to execute the mapping, the Log returns the following:
"Warning in object 'Resultset': A generic driver error occured.
Permission denied
DB_SEC_E_PERMISSIONDENIED (0x80040E09)"
and
"DB_E_ERRORSOCCURRED (0x80040E21)"
Has anyone encountered this issue before? Is there a way to resolve this, or shall I follow a different process to export the hierarchy into Excel?
Thanks.
