Just to elaborate in details: 1.I need to understand how much effort is required for the initial setup so that we can map it to cost figures. For example, if we need 2 Java developers and 1 System admin working for a month to set the tool up, we know we are talking about 3 FTEs worth of effort which we can convert to cost figures easily.
2.These are the high level requirement.We want our tool should help us to execute the below scenerio's example: Compare input and output record counts Compare input values and output values Validates transformations Compares checksums created against the input and output (e.g. The sum of input column 1 = sum of output column 1) Compare input with a filter record count with output record count Supports files and tables as either the input or output (File to Table, Table to Table, Table to File) Supports the validation of a test against a static value, e.g. Sum of column 1 = value x Supports embedded SQL to use for the validation routine, e.g. Output of SQL 1 is equal to the output of SQL 2 or Output of SQL 1 is equal to this expected value Compares checksums created against the input and output Compare input with a filter record count with output record count Supports files and tables as either the input or output (File to Table, Table to Table, Table to File) Supports the validation of a test against a static value, e.g. Sum of column 1 = value x Supports embedded SQL to use for the validation routine On Tue, Apr 30, 2013 at 3:25 PM, avineet gupta <[email protected]>wrote: > Thanks a lot Rob.It helps a lot.Just have few questions > 1.What would be skills set required and effort required to implement the > tool. > 2.Does it supports embedded SQL to use for the validation routine > > > On Fri, Apr 26, 2013 at 4:35 PM, Mandeville, Rob <[email protected]>wrote: > >> Do you mean Ab Intio? BTW, it’s Jenkins, not Jenkin.**** >> >> ** ** >> >> The procurement cost of Jenkins is zero. Just go to >> http://www.jenkins-ci.org and download. Cloudbees will sell you an >> enterprise edition with extra plugins and a support contract, or sell you a >> service where you run Jenkins on their cloud. I’d start with the free copy >> to see if it even meets your needs, then consider the possibility of going >> to Cloudbees (Truth in advertising: my company just bought their enterprise >> edition for the support contract).**** >> >> ** ** >> >> I have found nothing that specifically connects Jenkins to Ab Inito, >> Jenkins can run with a bunch of different tools because it supports running >> tasks as Windows batch scripts or Unix shell scripts. This is how it >> connects to all but a few general development tools.**** >> >> ** ** >> >> While Jenkins is useful for automating running of tests, I don’t think >> that it directly supports the sorts of tests that you show below. There >> are plugins to read *Unit style logs, or to read certain patterns (such as >> “TEST PASSED” or “TEST FAILED”) as pass/fail criteria, but doesn’t have the >> logic to compare results. Basically, you would have to write the tests >> yourself, generate simple pass-or-fail strings, and have Jenkins parse the >> logs for those pass-or-fail strings. The nice thing about Jenkins is that >> it will do so unattended, either on a schedule or whenever you submit a >> change to your source control system.**** >> >> ** ** >> >> --Rob**** >> >> ** ** >> >> *From:* [email protected] [mailto: >> [email protected]] *On Behalf Of *avineet >> *Sent:* Friday, April 26, 2013 6:05 AM >> *To:* [email protected] >> *Subject:* Questions on Jenkin**** >> >> ** ** >> >> Hi,**** >> >> We wanted to implement Jenkin in our project which require some kind of >> automation tool which support testing around Abnitio.**** >> >> I have heard that Jenkin works with Abnitio,Could you please confirm me >> the same. >> *What would be the Procurement cost of the product. >> * >> Also,I drafted few high level cases which we want the tool should >> support.Could anyone please have a look and let me know if these cases >> works with Jenkin. >> >> Compare input and output record counts >> Compare input values and output values >> Validates transformations >> Compares checksums created against the input and output (e.g. The sum >> of input column 1 = sum of output column 1) >> Compare input with a filter record count with output record count >> Supports files and tables as either the input or output (File to >> Table, Table to Table, Table to File) >> Supports the validation of a test against a static value, e.g. Sum of >> column 1 = value x >> Supports embedded SQL to use for the validation routine, e.g. Output >> of SQL 1 is equal to the output of SQL 2 or Output of SQL 1 is equal to >> this **** >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> **** >> The information in this message is for the intended recipient(s) only >> and may be the proprietary and/or confidential property of Litle & Co., >> LLC, and thus protected from disclosure. If you are not the intended >> recipient(s), or an employee or agent responsible for delivering this >> message to the intended recipient, you are hereby notified that any use, >> dissemination, distribution or copying of this communication is prohibited. >> If you have received this communication in error, please notify Litle & Co. >> immediately by replying to this message and then promptly deleting it and >> your reply permanently from your computer. >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Jenkins Users" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to [email protected]. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > Thanks and Regards.. > Avineet > -- Thanks and Regards.. Avineet -- You received this message because you are subscribed to the Google Groups "Jenkins Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
