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
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
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 ?
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.