I'm trying to understand the relationship between the Bulk_Row_Count, Commit Intervals, and the Max_Error_Count in the advanced properties of Data Management Studio, especially in the case of an Oracle database. For example, if I set the Bulk_Row_Count at 1,000, should the commit interval be set at 1,000 as well? In terms of performance should there be a scenario where these two values are different?   Also, I need to load 1.5+ million records on regular basis, and was considering using the Bulk_Row_Count option. Each one of these records is important , and needs to be accounted for. In this scenario would I set the Max_Error_Count to 0 (which I assume fails the job after it encounters the first error) along with setting the Bulk_Row_Count, or does setting Max_Error_Count to 0 nullify the performance gains from the Bulk_Row_Count? I could also use Status_Field property to determine if a inserted record failed, but would this be advised when using the Bulk_Row_Count? ... View more

I'm trying to make use of the setoutputslot functionality in Dataflux Studio, and I'm not sure I understand how to implement it. In the job that I'm working on there are 2 different types of files that I need to process. As the two different files are related to the same project and potentially we will receive the files at the same time, I'm trying to use two different data jobs within the same process job to process them. I'm using a process table reader to loop through the different filenames, and based on the filename have an expression node redirect the flow to the appropriate data job. Once its looped through both filenames in the process reader, and the process reader has an EOF status the job should end. Therefore, I assume that I need 3 output slots: one for filename #1, one for filename #2, and one for the exit. What I initially thought was that the expression node would support multiple output slots, and that the setoutputslot would be somewhat similar to a branch, where the flow was just redirected. I've tried to created create multiple output slots on the expression node but it only allows me one slot. How can I direct the flow if only 1 output slot is available? An example job using the setoutputslot functionality would be extremely appreciated. ... View more

Does DataFlux Management Studio support making web service calls using client certificate authentication? Note, I'm not referring to Management Server's ability to generate web services. I want to call an external web service that uses certificate authentication. Does DataFlux support this through either the HTTP request node or the Web service node? The external web service that I want to call currently supports REST so it would be better to do this using the HTTP request node from what I understand. Can anyone provide any example of a job that uses an HTTP request where certificate authentication is configured?   Thank you,   Kevin ... View more