Extracting Data from MySQL

OL Connect Professional Workflow
1

Hello

I am new to this and I need to try to get the data extracted from a pdf or CSV file into a useable format eg. to see the processed account number, letter type and date. I gather I could do this in the datamapper and then create a CSV at the final stage (some help doing this would be good) but can I also use the data within MYSQL? All the metadate must be there but the tables don’t seem all that obvious. The datacolumnschema seems to hold the column headers for the metadata but where is the actual data?

I would assume that datacolumnschema would hold the key to the data heading and datavalue holds the actual data.

I was hoping to run a batch at the end of the workflow to copy the relevant data (set up as a view) to a different database. Is this possible?

Thanks

Nigel

2

No need to access the database directly, the Retrieve Items task will do that for you. It will retrieve entre records (as long as they’re not including detail tables) and store them in metadata, which you can then save as XML.