topic Re: Implement business rules in Talend in Talend Studio

Implement business rules in Talend

Anonymous — Sat, 16 Nov 2024 12:37:16 GMT

Good day!
Someone tell me if there are any component that can put business rules or decision Tables.
I'm looking for the best way to implement business rules, in order that they may be adjustable.
I hope I can help.
Greetings!

Re: Implement business rules in Talend

Anonymous — Mon, 17 Oct 2011 16:19:19 GMT

Hi caapi,
You can find two components available in Talend Integration Suite Professional Edition and higher versions. Both of these are: tRules & tBRMS. These components use Drools rule engine.
Best,
Pcoffre.

Re: Implement business rules in Talend

Anonymous — Mon, 17 Oct 2011 17:23:51 GMT

Thank you very much pcoffre
¿TOS has no components of this type?

Re: Implement business rules in Talend

sizhaoliu — Mon, 17 Oct 2011 19:01:04 GMT

TOS does not provide this functionnality.
But in TOP, there is a indicator named "DQ Rules", which do not use Drools technology, but can also satisfy some business needs.
(have a look at http://www.youtube.com/watch?v=e3PD32TD0dA)

Re: Implement business rules in Talend

Anonymous — Tue, 19 Mar 2013 15:36:36 GMT

Can you point me to a good document about tRules? Following the component guide scenario in the studio's help section, I have the following exception when running the job applying RuleAGE and RuleREGION.
"Unable to resolve ObjectType 'row1Struct' : "
Thanks!

Re: Implement business rules in Talend

Anonymous — Wed, 20 Mar 2013 06:51:54 GMT

Hi eric,
What talend product version do you use? Perhaps our article need to be updated with the product upgrade. We will make a testing for it. You can go to the component reference tRules, and give us your precious suggestion on this page directly.
Best regards
Sabrina

Re: Implement business rules in Talend

Anonymous — Wed, 20 Mar 2013 15:52:47 GMT

5.2.2 is the right version. Do you have the .xls file and the job? Do we need to import any jar?

Re: Implement business rules in Talend

hmassy — Fri, 15 Nov 2013 09:44:00 GMT

Hello Eric,
I could reproduce the error you got using the tRules Job in 5.4.
To be able to run the Job without any exception:
-make sure to name the output schema of the tRules component using the exact names of the rules in the Excel Drools file.
-make sure to use the exact project and job names in your studio when you fill in the Import field in the Excel Drools file. You should use the following format in the Import field: <projectname>.<lowercase jobname>_0_1.<jobname>.*. For example, dq_project.business_rule_0_1.Business_Rule.* means that the name of the project in the studio is dq_project and the name of the Job is Business_Rule.

If you still need the Job, the .xsl file and the input file, please contact me at "hmassytalendcom" that I can send you the job and the files.
Hiyam MASSY
Documentation team

Re: Implement business rules in Talend

Anonymous — Tue, 27 Jan 2015 15:31:00 GMT

5.2.2 is the right version. Do you have the .xls file and the job? Do we need to import any jar?

Hi, I am also interested in testing the job described in the documentation:
https://help.talend.com/search/all?query=tRules&content-lang=en
Could you provide me with the job and the 2 excel files please?
Thanks

Re: Implement business rules in Talend

hmassy — Fri, 30 Jan 2015 08:57:26 GMT

Hello Maxime,
We communicated yesterday about your needs and I sent you the files by email.
I'm attaching the job + the .xls files to this message as well in case other people are interested in testing tRules. The topic can be closed this way.
Hiyam MASSY,
Documentation team
tRule.zip_20150130-0955.zip

Re: Implement business rules in Talend

Anonymous — Thu, 01 Oct 2015 15:10:54 GMT

Hi hmassy,
I'm trying to use your example but when i run the job i have the following error :

Exception in thread "main" java.lang.NoClassDefFoundError: TestEsbSOAP/rules_0_1/Rules$row1Struct (wrong name: testesbsoap/rules_0_1/Rules$row1Struct)
	at java.lang.ClassLoader.defineClass1(Native Method)
	at java.lang.ClassLoader.defineClass(ClassLoader.java:800)
	at java.security.SecureClassLoader.defineClass(SecureClassLoader.java:142)
	at java.net.URLClassLoader.defineClass(URLClassLoader.java:449)
	at java.net.URLClassLoader.access$100(URLClassLoader.java:71)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:361)
	at java.net.URLClassLoader$1.run(URLClassLoader.java:355)
	at java.security.AccessController.doPrivileged(Native Method)
	at java.net.URLClassLoader.findClass(URLClassLoader.java:354)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:425)
	at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:308)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	at java.lang.Class.forName0(Native Method)
	at java.lang.Class.forName(Class.java:274)
	at org.drools.util.CompositeClassLoader$CachingLoader.load(CompositeClassLoader.java:262)
	at org.drools.util.CompositeClassLoader$CachingLoader.load(CompositeClassLoader.java:241)
	at org.drools.util.CompositeClassLoader.loadClass(CompositeClassLoader.java:88)
	at java.lang.ClassLoader.loadClass(ClassLoader.java:358)
	at org.drools.base.ClassTypeResolver.importClass(ClassTypeResolver.java:274)
	at org.drools.base.ClassTypeResolver.resolveType(ClassTypeResolver.java:173)
	at org.drools.rule.builder.PatternBuilder.build(PatternBuilder.java:162)
	at org.drools.rule.builder.PatternBuilder.build(PatternBuilder.java:122)
	at org.drools.rule.builder.GroupElementBuilder.build(GroupElementBuilder.java:65)
	at org.drools.rule.builder.RuleBuilder.build(RuleBuilder.java:81)
	at org.drools.compiler.PackageBuilder.addRule(PackageBuilder.java:1813)
	at org.drools.compiler.PackageBuilder.addPackage(PackageBuilder.java:745)
	at org.drools.compiler.PackageBuilder.addPackageFromDrl(PackageBuilder.java:338)
	at org.drools.compiler.PackageBuilder.addKnowledgeResource(PackageBuilder.java:567)
	at org.drools.builder.impl.KnowledgeBuilderImpl.add(KnowledgeBuilderImpl.java:34)
	at testesbsoap.rules_0_1.Rules$1KnowledgeBase_tRules_1.readKnowledgeBaseXLS(Rules.java:1028)
	at testesbsoap.rules_0_1.Rules$1KnowledgeBase_tRules_1.readKnowledgeBase(Rules.java:978)
	at testesbsoap.rules_0_1.Rules.tFileInputDelimited_1Process(Rules.java:1059)
	at testesbsoap.rules_0_1.Rules.runJobInTOS(Rules.java:1758)
	at testesbsoap.rules_0_1.Rules.main(Rules.java:1615)

Can you help me ?
Best regards.
Takago.