topic Re: Data Remediation: create new issue types from SQL tables in SAS Data Management

Data Remediation: create new issue types from SQL tables

HeidiDT — Fri, 24 Mar 2023 15:13:23 GMT

I am brand new to data remediation and am still busy with the design for our data remediation processes. I am currently configuring the landscape by creating the applications, subject areas and issue types. I want to create an issue type for each field in our data - which is a lot so I don't want to do it manually as I would want to replicate it in our DEV, TEST and PROD environments and I would also like to be able to dynamically add an issue type if a new field is added. Is there a way to programmatically add issue types from SQL tables? I have googled but haven't been able to find anything yet, so any help will be greatly appreciated.

Re: Data Remediation: create new issue types from SQL tables

SASJedi — Fri, 31 Mar 2023 12:53:30 GMT

@HeidiDT If you would please share the following, it will make it more likely that someone here can provide some advice:

1. A few rows of the data set (table) that you already have.

2. A copy of any SAS code you've already written to try to solve the problem.

3. A few rows of the data set (table) as you want it to be after processing.

Re: Data Remediation: create new issue types from SQL tables

HeidiDT — Wed, 05 Apr 2023 11:51:21 GMT

Hi @SASJedi and thanks for the reply. I have not created any issue types as yet, since I wanted to first find out whether it was possible to create issue types from a SQL table. I have no clue where to even start with the SAS code, since I don't know where the metadata for Data Remediation resides. I.e. I wouldn't know where to write to! I would guess the REST API would have to be used, but without having had any experience or training in Data Remediation (there are no SAS courses available so I have only gone through the User's Guide), I really have no idea where to start. I am perfectly happy creating each issue type manually and am able to do that, however I would like to be able to create the issue types dynamically / from a SQL table.

I hope this provides a bit more background?

Re: Data Remediation: create new issue types from SQL tables

SASJedi — Fri, 07 Apr 2023 20:22:58 GMT

@HeidiDT - I'm primarily a programmer and I think this sounds like a question for someone with more SAS Solutions experience. Are you working with the SAS® Data Remediation software?

Re: Data Remediation: create new issue types from SQL tables

HeidiDT — Wed, 31 May 2023 08:19:23 GMT

Hi @SASJedi , sorry I am only replying now, got pulled off to work on other priorities. Yes, I am working with SAS® Data Remediation software