search

S-C-O-U-T / Pyadomd

A pythonic approach to query SSAS data models.
https://pyadomd.readthedocs.io/en/latest/index.html
Apache License 2.0
25 stars 6 forks source link

Add support for ExecuteNonQuery method #18

Closed addlockwood closed 2 years ago

addlockwood commented 2 years ago

Adding support for Microsoft.AnalysisServices.AdomdClient.dll ExecuteNonQuery method. This will allow user to execute commands against the data model that do not return rowsets, such as processing the database. This action is useful in ETL pipelines that can refresh the Analysis Services database after new data has been loaded in the source.

S-C-O-U-T commented 2 years ago

Hey, thx for PR. Could you provide a test scripts. And an example of how to use it, that could be added to the readme.

addlockwood commented 2 years ago

I added a test script that shows how I was using it as a part of an ETL pipeline. I thought it might be a cool feature to add to the standard package. Not sure if this is enough for you, but let me know if you need more.

alexisechague commented 2 years ago

It could be very useful too for editing SSAS models, using TMSL commands, without generate the error "AdomdUnknownResponseException: The result set returned by the server is not a rowset."

addlockwood commented 2 years ago

Exactly! With it you can execute any of the SSAS commands that do not return data.

On Thu, Jun 2, 2022, 20:19 alexisechague @.***> wrote:

It could be very useful too for editing SSAS models, using TMSL commands, without generate the error "AdomdUnknownResponseException: The result set returned by the server is not a rowset."

— Reply to this email directly, view it on GitHub https://github.com/S-C-O-U-T/Pyadomd/pull/18#issuecomment-1145545276, or unsubscribe https://github.com/notifications/unsubscribe-auth/AONHXEQNZOPR6WAKMWD4ZD3VNF2VHANCNFSM5RORN5OQ . You are receiving this because you authored the thread.Message ID: @.***>

alexisechague commented 2 years ago

Thanks @S-C-O-U-T !!!