SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How do I promote a DataFlux (ver 2.5) custom QKB definition to the server ?

Accepted Solution Solved
Reply
New Contributor
Posts: 2
Accepted Solution

How do I promote a DataFlux (ver 2.5) custom QKB definition to the server ?

I have created a custom Standardization Definition in my local Windows based copy of DataFlux Data Management Studio ver. 2.5 that uses a newly created custom RegEx Library. I would like to know what needs to be transferred to our data management server running on Linux and what is the best way to accomplish this ? Can the export/import facility be used to do this somehow ? Thanks.


Accepted Solutions
Solution
‎09-13-2016 08:45 AM
SAS Super FREQ
Posts: 90

Re: How do I promote a DataFlux (ver 2.5) custom QKB definition to the server ?

The import/export functionality will let you move Quality Knowledge Base (QKB) definitions into and out of QKBs. In your situation though, unless the QKB on Linux is accessible to your Windows DM Studio environment through a network share of some kind, you'll probably need to copy the QKB on your Windows environment where the edits were made over to the Linux environment. Some important points:

 

  • t's always a good practice to make backup versions of your QKB directory before edits and copy/paste activities
  • Only replace the entire QKB on Linux if you're sure it's the same as your DM Studio environment. If you're not sure, you can copy the Linux-based QKB over to Windows, register it, use the export command to export the definition from the Windows-based QKB, use the import command to bring the definition into the Linux-based QKB, and then move the Linux-based QKB back out to the Linux server.
  • If you are copying the entire QKB, you'll want to copy all the files and directories from the version number on. So for example, all the directories and files starting here on a default QKB installation on Windows would need to be copied to your Linux-based DM Server environment: C:\ProgramData\SAS\SASQualityKnowledgeBase\CI\27
  • If you already have run jobs/process on DM Server that use the QKB, they may still be loaded into memory along with the QKB. Use the "unload" feature in the DM Server manager component of DM Studio to unload the jobs from memory. If you find that your changes are not being picked up, you may need to restart your DM Server before attempting to run the job again.

Ron

View solution in original post


All Replies
Solution
‎09-13-2016 08:45 AM
SAS Super FREQ
Posts: 90

Re: How do I promote a DataFlux (ver 2.5) custom QKB definition to the server ?

The import/export functionality will let you move Quality Knowledge Base (QKB) definitions into and out of QKBs. In your situation though, unless the QKB on Linux is accessible to your Windows DM Studio environment through a network share of some kind, you'll probably need to copy the QKB on your Windows environment where the edits were made over to the Linux environment. Some important points:

 

  • t's always a good practice to make backup versions of your QKB directory before edits and copy/paste activities
  • Only replace the entire QKB on Linux if you're sure it's the same as your DM Studio environment. If you're not sure, you can copy the Linux-based QKB over to Windows, register it, use the export command to export the definition from the Windows-based QKB, use the import command to bring the definition into the Linux-based QKB, and then move the Linux-based QKB back out to the Linux server.
  • If you are copying the entire QKB, you'll want to copy all the files and directories from the version number on. So for example, all the directories and files starting here on a default QKB installation on Windows would need to be copied to your Linux-based DM Server environment: C:\ProgramData\SAS\SASQualityKnowledgeBase\CI\27
  • If you already have run jobs/process on DM Server that use the QKB, they may still be loaded into memory along with the QKB. Use the "unload" feature in the DM Server manager component of DM Studio to unload the jobs from memory. If you find that your changes are not being picked up, you may need to restart your DM Server before attempting to run the job again.

Ron

New Contributor
Posts: 2

Re: How do I promote a DataFlux (ver 2.5) custom QKB definition to the server ?

Ron, thank you for this information. I was hoping that I would be able to directly copy needed files to the server as we often do with schemes, but I guess this is much more involved for definitions. I think I prefer the idea of copying the qkb to my local environment and using the export facility rather than replacing the whole qkb. In my case, however, we have multiple people altering local qkb's so  I have opted to accomplish what I was doing with the definition by writing some expression code instead. This was the simpler and safer approach for now.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 303 views
  • 1 like
  • 2 in conversation