DTW - Import data through ODBC

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hello John,

I didn't understand how you have proceeded. xl template imported into sql???

Could you clarify ?

thanks

[Former Member]

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

[Former Member]

Hi Anton,

I'm used to import data through DTW from txt files.

I want now to import from SQL tables into SBO through DTW

What I want to do?

for example : I want to create Marketing Documents from user tables I have created in SQL.

[Former Member]

Hi Christian,

You must select data from your SQL tables and fill up the Excel templates for marketing docs with this data.

Anton.

[Former Member]

Ok Anton,

I encountered some problems when selecting data from SQL, probably due to syntaxes in queries which work within SQL server management studio but not within DTW.

Could you give me a few queries that do work within DTW, as samples.

Thanks

Christian

[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.

[Former Member]

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

[Former Member]

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