Skip to main content
Solved

Compare sql caalog vs file


i have a sql catalog in one web and i have a file in sharepoint now what is the best way to compare the contents of sql catalog and file ?

will virtual catalog help ? if yes how could i do it ? 

 

my idea is to join sql catalog and file as full join in one desktop and use this joined data as a catalog in one web application . how to do it ?

Best answer by ivan.kozlov

Hi ​@lokeshpotti ,
Indeed you can achieve this using VCI’s.
You’ll need to use Catalog Item Reader step in VCI and read the SQL catalog item you’ve created and if you’d like to read some file as well, you’ll need to upload it to some storage like S3 or ADLS, add the connection for this storage into DPM Runtime Config and reference the file using resource://resourcename/…. notation. 
I hope this helps,
Ivan

View original

ivan.kozlov
Ataccamer
Forum|alt.badge.img+3

Hi ​@lokeshpotti ,
Indeed you can achieve this using VCI’s.
You’ll need to use Catalog Item Reader step in VCI and read the SQL catalog item you’ve created and if you’d like to read some file as well, you’ll need to upload it to some storage like S3 or ADLS, add the connection for this storage into DPM Runtime Config and reference the file using resource://resourcename/…. notation. 
I hope this helps,
Ivan


Thanks for the answer. 

Currently i am establishing file connection i will ask further question if any during the creation of vci


Hi ​@ivan.kozlov 

 

In Addition to the above question - Can i directly use the file (excel ) available in share point while joining with the sql catalog in One Desktop and then i use the virtual catalog in one web to create the rules and remediation ?


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings