Changing the External Source underlying the data set

Manoj Bhosle
Manoj Bhosle Member
edited December 2023 in General

Hi,

We have developed several workflows using several data sets that are sourced from a particular External Data Source. Now the external data source is moved and renamed.

Is there a way to point the Datasets to the new External source ?

Many Thanks.


Regards,

Manoj Bhosle

Answers

  • Josh Boxer
    Josh Boxer Administrator

    Hi Manoj

    Datasets are tightly tied to the external source system they were created from. This is something we would like to improve in future, but for now unfortunately there is not a simple way to switch to point a Dataset at a different system.

    The Associations functionality will help to quickly determine where each Dataset is bring used or alternatively looking at each Workflow you can see what it depends on:

    image.png

    https://docs.experianaperture.io/data-quality/aperture-data-studio-v2/get-started/associations/

  • Manoj Bhosle
    Manoj Bhosle Member

    Hi Josh,


    Thanks for quick response. Power BI offers such feature and hence the Users were asking. Thanks for clarifying - this at least helps to manage the User expecations.


    Regards,

    Manoj Bhosle

  • Henry Simms
    Henry Simms Administrator

    To add to this:

    • It is possible to edit an External System to change certain values. So if your SQL Server instance has moved for example, you can edit the hostname, credentials etc. But if the source changes from SQL Server to a different DBMS, you would need a new External System and then load new datasets
    • Using Views in Data Studio is a way to avoid this problem: If workflows are configured to use a View as Source rather than a Dataset, then only the View would need to have its source re-mapped if the underlying Dataset needs to be swapped out:
    image.png


Categories