Data Stream in Tool is long taking time

[tjamal1]

I am using python tool to output data to data stream in tool but it is taking very long time 

Data Stream IN Tool uses DB which is in another server

Records :8.2 million 

SQL 

Is there anyway to fix this issue ? 

[VianneyM]

hi @tjamal1,

To which database are you connecting? and which driver are you using?

Have you tested the connection with 1000, 100000 rows?

Can you define very long time? How long is that?

Best,

Vianney

[tjamal1]

SQL Server

SQL Client 11.0 Driver

very long means : in Data Streaming it slowly forwarded to data streaming  3000 records/30 seconds   , so i have to stop workflow 

[VianneyM · Accepted solution]

hi @tjamal1,

Have you tried this option within the output tool

https://help.alteryx.com/current/SQLServerConnections.htm

Best,

Vianney

[tjamal1]

That solved the issue greatly. 

Thank you