Can anyone share any experience with connecting Data Integrator to an ADP Payroll Database or ADP’s ETIME Database?
gfkoss 
(BOB member since 2006-03-06)
We are doing some ETime & ADP extracts. Sort of have to jump through hoops to get it, but it is possible.
Darlene
hueymoo (BOB member since 2005-02-25)
Thank you. Are there any pointers that you can share?
gfkoss (BOB member since 2006-03-06)
In Etime, you can use data poster to export to dbf. All of the table info is in the TKPWIN.HLP file.
We then run an excel macro to open these .dbf files and save as Excel.
Then create an ODBC data source for BO DI to use. Even the data poster script can be automated.
As far as ADP goes, we are using the Oracle version. I was told that if the SQLBase was 32 bit you should be able to get an ODBC driver for it.
Neither piece of software is very user friendly as far as reports go.
Good luck
hueymoo (BOB member since 2005-02-25)