Skip to Content
author's profile photo Former Member
Former Member

DTW - Import data through ODBC

Hello,

I would like to import data from SQL tables using DTW.

It sounds like DTW can do that but my first tests are not conclusive.

I want to know if anybody has some experience on the subject and could give me some examples.

thanks in advance

Christian from France

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 06:56 PM

    I import the xl template into sql to get the table schema.

    and I use ODBC with DTW.

    note: once you start importing more than 7,000 records in one table, performance degrades (I suspect there is a memory leak).

    I have written my own di app to load customers when I had to load 100,000 business partner records for one of our clients.

    hth

    john

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 11:30 PM

    Christian

    Have you looked at any of the Third party products such as Xfusion Studion offered by Software labs? We have had very good results with their product

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 11:30 PM

    Christian

    Have you looked at any of the Third party products such as Xfusion Studio offered by Software labs? We have had very good results with their product

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 30, 2007 at 12:36 PM

    Hi there Christian,

    DTW is a tool for import data to SAP Business One not from it.

    What do you want to import? Can you describe it more precisely?

    Regards,

    Anton

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Christian,

      DTW ISN'T working with SQL-queries only with txt files.

      All you must to do is select data from your SQL-tables, copy this data to necessary Excel template, save it to txt file and import this file through DTW.

      Regards,

      Anton.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.