Thanks Rob!! What are the source control systems that Jenkins supports? Ab Initio has its own source control as part of the EME which does include a command line interface but can Jenkins be used to access it?
On Tue, Apr 30, 2013 at 5:42 PM, Mandeville, Rob <rmandevi...@litle.com>wrote: > The high level requirements you are giving (compare record counts, run > two SQL commands and compare the results, compare test results from static > values) are requirements for a test harness, not a continuous integration > server. If you don’t have a test harness, Jenkins cannot help you. If you > have a test harness, Jenkins can run it for you whenever somebody checks a > change in to your source control.**** > > ** ** > > If you have:**** > > 1: A source control system supported by Jenkins**** > > 2: A command-line build process to create your program (I believe they’re > called “Graphs” in Ab Initio)**** > > 3: A command-line test harness that Jenkins understands (there are plugins > for several, and the Build Log Parser plugin can be used to read results > like “TEST PASSED” and “TEST FAILED”)**** > > ** ** > > Then a release engineer can make something demoable in a matter of days, > not weeks. Basically, they’ll be able to get Jenkins to poll the source > control system every *n* minutes, and when something changes, it can > check out your code, run your command-line-based build procedure and then > your test harness. **** > > ** ** > > If you’re asking for a tool that will compare record counts, expected vs. > actual results, or SQL validation, you need a test harness, and Jenkins is > not a test harness. Jenkins runs test harnesses for a living, but you need > such a harness first.**** > > ** ** > > --Rob**** > > ** ** > > *From:* jenkinsci-users@googlegroups.com [mailto: > jenkinsci-users@googlegroups.com] *On Behalf Of *avineet gupta > *Sent:* Tuesday, April 30, 2013 6:27 AM > > *To:* jenkinsci-users@googlegroups.com > *Subject:* Re: Questions on Jenkin**** > > ** ** > > 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 <avineet.gupt...@gmail.com> > 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 <rmandevi...@litle.com> > 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:* jenkinsci-users@googlegroups.com [mailto: > jenkinsci-users@googlegroups.com] *On Behalf Of *avineet > *Sent:* Friday, April 26, 2013 6:05 AM > *To:* jenkinsci-users@googlegroups.com > *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 jenkinsci-users+unsubscr...@googlegroups.com. > 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 jenkinsci-users+unsubscr...@googlegroups.com. > 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 jenkinsci-users+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > **** > > -- > 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 jenkinsci-users+unsubscr...@googlegroups.com. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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 jenkinsci-users+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/groups/opt_out.
