Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Refresh Dataset in 2 batches to avoid two hour time-out

Hello,   I'm facing an issue when I cannot complete a refresh due to two hour refresh limit. My datasource is Teradata and I'm loading 10 different tables.    My main question is: 1. Is it possi...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous 

1. If you are using Premium, you can split the refresh by using a dataflow. 

2. We have tried both and found the .NET Driver for ODBC didn't perform better. I have found that odbc sources add additional maintenance on the gateway. 

3. The timeout is on Teradata. You can overwrite that in the advance settings of your query. Also, check with the Teradata dba if they aren't throttling your user. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hello Anonymous and thanks for help.

     

    Just to be more specific regarding point 2 - are you trying to say that ODBC will be faster? What do you mean by additional maintanance on the gateway? 

     

    Thanks! Kamil