What I want to do is retrieve the data from external SQL server database and bring it on the SharePoint 2013 site and show the graphs accordingly. So the data might be from different database tables. And data may be in large amounts, I tried doing it using BCS connectivity by creating
External Content Type. But when I do it using tables or Views in SharePoint Designer 2013. It is giving me the error as,
"Database Connector has throttled the response. The response from database contains more than '2000' rows. The maximum number of rows that can be read through Database Connector is '2000'. The limit can be changed via the 'Set-SPBusinessDataCatalogThrottleConfig' cmdlet."
Now when I change the threshhold limit to 50,000 using powershell, then also it is giving me the same error for 50,000 items. So I tried it by doing through Stored Procedure, but there it is not able to create
External Content Type because of the schema name, and giving the error as
"Cannot retrieve SQL Server routine return parameter schema informaiton. Invalid object name 'dbo.Information'.".
How to do deal with these type of issues. Does anybody have solution.