DTW and ODBC

[Former Member]

Greetings,

My current version of DTW will not refresh its list of DSN ODBC even if I've created new DSN's. Has anyone ever come across this before?

Also, we have a client that would like to abandon their current SAP B1 database and move to a new company, and the new company will have extensive segmentation in the chart of accounts. As such, I doubt copy express will work (because it keeps looking at the default BP GL codes).

Would it be much easier to use DTW (and ODBC) to draw the BP codes from the older DB and import it into the new B1 DB? If so, has anyone else ever tried using the ODBC feature in the DTW?

Thanks in advance!

Davinder

[former_member583013]

As you might be already aware copy express will only copy the Config and COA as is. So it you changing the structure you need to import a Fresh.

[Former Member]

Thank you.

Also, the DTW only looks at User DSN. What confused me was that some of my System DSN also was showing up but didn't update when I updated the System DSN.