1 Reply Latest reply on Jul 12, 2020 10:36 AM by Pravanth Kkumar

    Profiling More than One Schema in an Azure SQL Data Warehouse resource using the same Source Connection

    Amarendra Reddy Active Member

      You can scan multiple schemas in an Azure SQL Data Warehouse, by specifying schema names in the field in the metadata load settings while creating the resource in Catalog Administrator.  Metadata load is successful and you can all schemas.

       

      However, to profile, we need to select a source connection.  The source connection is created in Informatica Administrator and one of the required fields is "Schema Name".  Profiling is running successfully for one schema, but it is failing for multiple schemas.

       

      It is tedious to create a separate connection in Informatica Administrator and a separate resource in Catalog Administrator for each schema to be able to profile.  Is there any way we can profile all the schemas in an Azure SQL DW resource with the same source connection?