How to import more than 1 millions records in Streaming DB Connector?

book

Article ID: KB0080534

calendar_today

Updated On:

Products	Versions
Spotfire Statistica	13.1 and higher

Description

While importing data through queries in Streaming DB connector, it can only handle data with no more than 1 million records by default.
This KB articles shows how to set the Streaming DB connector, so that it can import more than 1 millions records without any error.

Environment

Windows

Resolution

1. Open Statistica and go to File | Options and select Streaming DB connector.

2. Check if the option Assume Fewer than is enabled or not: If enabled, the default value is set to 1,000,000, which prevents the Streaming DB connector from working well with data exceeds 1 million records.

3. There are two options to resolve this issue:

a) Increase the upper limit in the Assume Fewer than option.