Data Studio v2.0 - Export JDBC Error 9002
We are trying to export data back to database.
We have updated the export definition as follows:
Unable to add screen dump - below is what we entered in export definition:
Exporter = JDBC
DBMS system = DQ Analysis Test
Table Name = ADDRESS_OUTPUT
Mode = Insert
Truncate Table = true
Pre SQL <empty>
Post SQL <empty>
We run the export function and we receive a 9002 error
An unexpected error has occurred during Workflow execution: 9002: An error occurred while executing a workflow
- Do we need to change what we have inputted above or are we missing information?
- Its our first time exporting to database, do we need to do anything within the application?
- Error 9002, how do you know what this error is?
Any assistance would be appreciated