How to import more than 1 millions records in Streaming DB Connector?
Article ID: KB0080534
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.
This KB articles shows how to set the Streaming DB connector, so that it can import more than 1 millions records without any error.
Issue/Introduction
How to import more than 1 millions records in Streaming DB Connector?
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.
b) Enable the Automatically determine option.
Feedback
Yes
No
Powered by
