Update Smartsheet table with data from SQL DB

calcioscacchi

HI there.

I'm not very familiar with SMartsheet yet, but i'm gradually getting the hang of it.

I succeed to connect a sheet in PowerBI with the integrated connector, and now I need a step forward: I have some data in SQL tables and i'd like to take those data from SQL BS server and upload a table in Smartsheet.

I was looking for this here in the forum but I only got the inverse process, that is to update a SQL DB from Smartsheet.

Any way to do that?

Thanks!

Darren Mullen

@calcioscacchi

There's not great off the shelf way to do this. Also, you'll have to ensure you don't exceed any sheet limits on the amount of cells you can bring in.

Are you trying to keep the data in sync with the SQL database or just a one time import?

If you need to keep it in sync, you'll need a bridge between the SQL data base and Smartsheet.

If a one time import you can export the SQL data in CSV and import into a new sheet, or if you have Data Shuttle into an existing sheet. If you don't have Data Shuttle and want to import into an existing sheet, then you'll either need bring it in over the API or use an extension like this :

https://youtu.be/Y2BsWpV9vHc?si=XTDDArX5x3emIKSi

calcioscacchi

I need to keep it sync.

Specifically, I am required to record the causes of certain events—mainly issues—in Smartsheet, with the location of each issue being sourced from the SQL Server.

So, just for a easy example:

I have 8 bathes per day, any of them could have a issue.

-I have to record the cause of that issue;

-The batch number must be taken by SQL server.