We have requirement to send the database records from DB and convert it into flat file and send to other system using webMethods.
But the data has to be pushed into a single flatfile, there are 25,000 records in a batch. This needs to run daily.
We are thinking to push the data using the same batch number, which is inserted into the buffer table (notification is configured on this buffer table). The publisher will read every 500 records and publish the canonical to the broker.
Now the subscribe read this canonical and converts into the flat file using ffschema and append to the batch file.
Till this point we are fine, wat is going to happen if the publisher published four canonical to the broker, then we will have 4 subscribers writing/appending to the same flat file.
We need a solution,where the subscriber should need to generate a tag/ some indicator that the file writing is complete.
2. Or making the subscriber to read the canonicals sequential, do we have any mechanism in webmethods?
3. Can subscriber go back to the DB for any cross reference?
Please help us on this?