AnsweredAssumed Answered

Can I Save a Database Query to csv without using a Map?

Question asked by BenMiller3461 on May 11, 2016
Latest reply on May 19, 2016 by BenMiller3461

For my process I am simply doing a query on the database for inventory in the below format.  I then need to save these results as a csv file.  It is a 153,893 rows.  The problem I have with this process is the mapping, doing a direct map from a database profile to an identical csv profile takes 7 minutes.  The query takes less than 30 seconds and then the mapping takes 7 minutes.  I don't think it really should need a map, assuming there is functionality to do this sort of thing. 

 

I'm even considering doing something like a find and replace on the data to accomplish this, as it seems like it would be a much quicker way to accomplish the same thing, though I don't know how to do that in boomi either. 

 

If anyone knows a way to speed up a simple mapping like this or a way to avoid the map all together, please let me know. 

 

example data:

id, sku, upc, actual_qty, unallocated_qty

Outcomes