Skip to main content

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 ?

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