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 <[email protected]>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:* [email protected] [mailto: > [email protected]] *On Behalf Of *avineet gupta > *Sent:* Tuesday, April 30, 2013 6:27 AM > > *To:* [email protected] > *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 <[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. > > **** > > -- > 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 -- 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.
