Discussion:
writing to excel
(too old to reply)
tharun reddy
2018-09-11 06:43:25 UTC
Permalink
how to write the data in to excel file with attributes
Eddie Hartman
2018-09-11 08:00:15 UTC
Permalink
Post by tharun reddy
how to write the data in to excel file with attributes
The easiest way is to use a File Connector with the CSV Parser. I've noticed that Excel on Windows expects comma-separated values (not the default semi-colon for the Parser).

If you want to explore other approaches then you have these posts:
http://www.gattis.org/Work-and-Tech/iam/tivoli/tdi-to-excel
(read through this thread for a JDBC approach)
https://groups.google.com/forum/#!topic/ibm.software.network.directory-integrator/RCUUXO6z2ec
(the COMProxy object gives you COM access in Windows)
https://www.ibm.com/support/knowledgecenter/en/SSCQGF_7.2.0/com.ibm.IBMDI.doc_7.2/referenceguide601.htm
https://www.stephen-swann.co.uk/javadoc/tdi7.0/com/ibm/di/automation/COMProxy.html

Hope this helps!
/Eddie

Loading...