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!!!
Discussion posts and replies are publicly visible
Are you referring to this?
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.
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.
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 -
Unknown said: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.
But, sorry OP I can't see any information about the limitation here.
Use Excel tools plugin.
So if you take a look at the above thread, you'll know that this is no more included in that plugin.