Change a Dataset and Replace All Downstream Processes With It?

ElliotGitter · 2022-10-11T16:56:20+00:00

There was an error rendering this rich post.

Hi everyone,

I'm working on updating some datasets in a new workflow. My example is switching from a dataset using an ODBC WB connector to a Microsoft SQL Server Connector. Is there a way I can change the dataset over (including all ETLs not only cards etc)? Either UI or API?

Thanks,

Find more posts tagged with

Accepted answers

All comments

GrantSmith

Currently there isn't a simple way to do this and it must be done manually.

ST_Superman

I feel like there might be a way to force the dataset ID to match the ID that the WB was using. If you did that and deleted the WB dataset, would that work? Kind of theory crafting here... but I thought the other ETLs, etc. pulled the dataset in by looking at the dataset ID. So, as long as your replacement dataset had the same dataset ID, wouldn't that work?

ElliotGitter

@ST_-Superman-_ I'll give it a try and see if there is a way. Still working on differences when I change from an ODBC to a SQL connector