Question

Export to sql rows limit

Forum|Forum|3 years ago
June 15, 2023
6 replies
0 views

Hi Everyone,

what is the limit on number of rows in export to sql smart service. I had an requirement to export around one to two lakh rows in an excel.

Any other way that i can acheive it if export to sql smart service had limit?

Thanks in Advance!!!

mathieud0001

Brainy

Are you referring to this?

[View:https://docs.appian.com/suite/help/23.2/Export_To_Excel_Smart_Service.html]

S

sanchitg0002

Export SQL to Excel smart service is present in "Excel Tools" plugin, you can download this plugin from App market and check if there is any limitation mentioned in the documentation. Keep in mind that this smart service is deprecated.

mathieud0001

Brainy

Are you sure?

It's not listed in the list of Smart Services https://community.appian.com/b/appmarket/posts/excel-tools

Nor can I see it in Process Designer:

In any case, if you are using this Smart Service - I would probably advise that you switch to something else as it seems as though it has been deprecated in later versions of the plugin.

S

sanchitg0002

yeah - It is not listed in the App market page and also in Process designer as this is deprecated from quite a long time now, which I already mentioned in my previous comment -

Keep in mind that this smart service is deprecated.

same is the case with Export CDT to Excel which is also deprecated and still working but have so many use cases relying on it that we can't resist to use it (major one is inefficiencies of Export DSE to Excel SS)

But if you try to search with "Export SQL" you'll see it's there and is also mentioned in the documentation provided with plugin.