Exporting Data to Azure Synapse Analytics

$inline[badge,Prerequisites,success]

  • Ensure the Azure Synapse Analytics target data connection is configured. For the steps to configure data connection, see $link[page,224603].
  • Ensure a database master key for the Azure Synapse Analytics is available.
  • To allow Infoworks to reach Azure Synapse Analytics, it is recommended to set Allow access to Azure services to ON on the firewall pane of the Azure Synapse Analytics server through Azure portal.

Setting Azure Synapse Analytics Target Properties

Following are the steps to use Azure Synapse Analytics target in pipeline:

  1. Double-click the Azure Synapse Analytics node. The properties page is displayed.
  2. Click Edit Properties, and set the following fields:
  1. Click Save.

Supported Datatype Mappings

Below is the list of supported source datatypes and their mapping to Azure Synapse Analytics datatypes:

VariableType to search · ESC to discard
GlossaryType to search · ESC to discard
InsertType to search · ESC to discard
No matches
On This Page