Elasticube - Changing number of row to import

SYMPTOMS

When you build an Elasticube and you get a timeout message during the build process when trying to copy data from the source database. This usually happens with slow ODBC driver or connection to web servces.

RESOLUTION

By default the "Data-import chunk size" value is set to 100,000. This works very well with the standard Database server such MSSQL, etc.

In order to optimize it for slower (web) connection set the "Data-import chunk size" to a value to a smaller value, which will cause the Elasticube to read fewer row on each pass.

I recommend to set this value to 1,000 to start with, and slowly increase between build if all goes well.

Please follow this link for documentation of "Data-import chunk size" ,