Hi There!
We are working on a project connecting to NetSuite. We are able to succesfully connect via the standard input data tool where 'NetSuite' is listed as supported, however in an ideal world we would like to use the In-database tools for this processing.
It is not listed as supported for these tools however we did note the 'generic ODBC' option which we tried, however when using this, though it establishes a connection and allow's us to use the visual query builder in the 'in-database input data' tool, when executing the workflow it returns the error 'Error SQLPrepare:[NetSuite][ODBC 64bit Driver][Open Access SDK SQL Engine] Syntax Error in SQL Statement'.
Though we believe this is simply a limitation of the product, given NetSuite is not neccessarily supported, we wanted to check whether anyone had any success connecting to this platform using the in-database method?
Otherwise we are looking for general advice on our other options to improve the execution speed of a workflow using standard input tools. So far we have the following list;
- During development use the limit clause in order to reduce the volume of records that your workflow is using
- During development use the 'caching' feature in order to not have to build the database input with each run
- Ensure we are selecting only relevant fields and aggregating data to the required level of detail for analysis
Thanks for your support!
Ben
