Talend

Talend - Open Data Integration, SSIS alternative and in Java-based with Apache license

https://www.talend.com/

Apache License: https://www.openfoundry.org/tw/legal-column-list/8581-the-elaborate-license-apache-20

SSIS comparison: https://www.trustradius.com/compare-products/sql-server-integration-services-vs-talend-data-integration

Possible Integration With CAPSIL

CAPSIL CL scheduled JOB with “RUNRMTCMD” ⇒ Tigger ⇒ .BAT JOBs or Java Based Tailor-made Scheduler in Talend Server

⇒ Execute Pre-Secheduled Tasks in Talend Server

⇒ Execute Data Extraction

⇒ Execute Report Generation

⇒ Perform ETL

⇒ Send Notification Email

⇒ Wait for files for processing

Reference

first talend job

https://www.talendbyexample.com/my-first-talend-job.html

using talend for data migration

http://www.adempiere.com/A_Step_by_Step_Guide_to_Data_Migration_with_Talend_ETL

run in command prompt with different context

http://www.vikramtakkar.com/2013/04/how-to-pass-context-parameters-to.html

export pdf

https://www.talendforge.org/forum/viewtopic.php?id=3619

run excel macro through powershell

https://www.talendforge.org/forum/viewtopic.php?pid=51170

remove excel privacy warning

https://superuser.com/questions/377583/how-can-i-prevent-the-privacy-warning-in-excel

enable execution of powershell script

https://stackoverflow.com/questions/4037939/powershell-says-execution-of-scripts-is-disabled-on-this-system

integrated with Jasper Report

http://bekwam.blogspot.co.id/2011/05/using-talend-as-datasource-for-jasper.html

disable excel macro and disable the warning

https://support.office.com/en-us/article/Enable-or-disable-macros-in-Office-files-12b036fd-d140-4e74-b45e- 16fed1a7e5c6#__toc311698309

understanding context variables

http://www.vikramtakkar.com/2013/04/how-to-pass-context-parameters-to.html

passing variables across groovy script

http://bekwam.blogspot.co.id/2011/04/passing-variable-out-of-tgroovy-with.html

Powershell Script Sample for running an excel macro - exportPdf.ps1

cmd /c powershell
cd <path_to_the_script_location>
./exportPdf.ps1

<<exportPdf.ps1>>
# $excel = new-object -comobject excel.application
$excel = new-object -com Excel.Application
$workbook = $excel.workbooks.open("C:\talend\exportPdf.xlsm")
$excel.Run("mainProcess")
$workbook.Save()
$workbook.Close()
$excel.Quit()
[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)
Remove-Variable excel
Stop-Process -name EXCEL

In Talend tSystem → choose to use Single Command and then for the “Command” textbox set as the following.

cmd /c start powershell -noninteractive -File C:\\talend\\exportPdf.ps1

AS400 Connection

Define in the Metadata

DBType: AS400

Connection String should be similar to:

jdbc:as400://xxx.COM.HK/xxxP;libraries=xxxP;transaction isolation=none;prompt=false;translate binary=true;naming=system;

Server: xxx.COM.HK

Database: xxxP

Additional Params: libraries=xxxP;transaction isolation=none;prompt=false;translate binary=true;naming=system;

Login: xxxx Password: yyyyy