Questions On Data factory/Polybase/SSIS Azure IR RRS feed

  • Question

  • Hi All

    I have some questions on Azure data factory

    1. Why need to create a master key for a database when using polybase ?
    2. How to combine SSIS and Polybase to load data to azure datawarehouse ?
    3. May I know for SSIS Azure Integration runtime, the SSIS catalog db can both be on Azure SQL database and Azure SQL managed instance ?

    Thursday, September 27, 2018 6:15 PM

All replies

  • For question 2., you can use Azure SQL DW Upload Task: https://docs.microsoft.com/en-us/sql/integration-services/control-flow/azure-sql-dw-upload-task?view=sql-server-2017.

    For question 3., you can use EITHER Azure SQL Database OR Managed Instance to host SSISDB for SSIS in ADF (Azure-SSIS IR).

    Friday, September 28, 2018 10:17 AM
  • for questions 2 & 3 . thankyou.~

    other questions

    Why need to create a master key for a database when using polybase ?

    what's an example of usage for tumbling window trigger ? what mean backfill scenarios?
    what's the different between selfhosted IR and cloud hosted runtime ?
    how to raise the power of Data factory IR / SSIS IR ?
    How to estimate how many pipelines can be run at a time to get better performance .

    Friday, September 28, 2018 6:30 PM
  • anyone has ideas on the questions ?

    May I know how to send email in a pipeline activities?

    Sunday, September 30, 2018 6:52 PM
  • anyone has the idea ?
    Monday, October 1, 2018 7:55 AM