|
Klassieke bestandstypen zijn vanaf januari 2021 niet meer beschikbaar voor gebruik. U kunt uw klassieke bestanden omzetten of een PDF downloaden. Meer informatie

Connecting MS SQL Server to Wdata

Beantwoord
Demo aanvragen
  • Bewerkt

Looking for information on connecting MS SQL Server to Wdata using Wdata Chains. Thanks. 

0

Opmerkingen

3 opmerkingen

Datum Stemmen
  • Officiële opmerking
    Wayne Paffhausen

    Hello Bharath,

    Connecting SQL to Wdata is no different than any other data source to Wdesk via Chains.  The purpose of Chains in any workflow is to connect source to target.  In this scenario your source system is SQL instead of an already produced file.  The result of your SQL Query is an output that you can use to feed into a spreadsheet or Wdata table.  The only additional step you are bringing into Chains is the idea of creating your dataset versus having it provided to you.

    Thank you,
    Wayne

  • Amitha Kumar

    Hi , Can we load WData tables to SQL server tables? 

    0
  • Jeff Hickey

    Hi Amitha Kumar,

    Yes, you can do the reverse of what is described above to extract data from Wdata and load it into Microsoft SQL Server. The related commands Execute SQL, Execute Update, Insert Records, and Upsert Records call all help with this task. You can find more information on each of these commands documented here https://support.workiva.com/hc/en-us/articles/360036005791.

    0

U moet u aanmelden om een opmerking te plaatsen.