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
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
+3Hi
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
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 ?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
