changing the output method from excel to SQL or table storage

[Pieterle-Roux]

How would I run the script so the output is written directly to a SQL database or table storage instead of into excel ?

[Claudio-Merola]

Hello there @Pieterle-Roux

The easiest way I can think if is to change every module to modify the Export-Excel part to input that variable into a SQL db

[Pieterle-Roux]

Hi Claudio Your response is much appreciated. We managed to do exactly that and we are appending the outputs to the database so we now have the ability to track historical changes as well regards Pieter Le Roux Lead: Cloud Altron Digital Business [altron.com digital business website]<https://altron.com/digital-business> w: altron.com/digital-business<https://altron.com/digital-business%20> This document is protected by Altron - labelled as General Business Information From: Claudio Merola ***@***.***> Sent: Wednesday, May 8, 2024 10:48 PM To: microsoft/ARI ***@***.***> Cc: Pieter Le Roux ***@***.***>; Mention ***@***.***> Subject: Re: [microsoft/ARI] changing the output method from excel to SQL or table storage (Issue #181) You don't often get email from ***@***.*** Learn why this is important<https://aka.ms/LearnAboutSenderIdentification> Hello there @Pieterle-Roux<https://github.com/Pieterle-Roux> The easiest way I can think if is to change every module to modify the Export-Excel part to input that variable into a SQL db - Reply to this email directly, view it on GitHub<#181 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/BGKLYCR2RUB6CXUCVMEGLQLZBKFP7AVCNFSM6AAAAABGM5DZWSVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDCMBRGQYTCMBZGA>. You are receiving this because you were mentioned.Message ID: ***@***.***>