<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: How to integrated EVD with Databases in Cloud (AWS &amp; Azure) in PAM Self-Hosted Discussions</title>
    <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297304#M1409</link>
    <description>&lt;P&gt;For any advanced configuration of EVD I recommend creating your own scripts that &lt;/P&gt;&lt;P&gt;a) retrieves the relevant datasets to CSV files using EVD, and then &lt;/P&gt;&lt;P&gt;b) uploads the CSV files to tables in your database using an appropriate command-line ETL for the database provider of your choice (eg SQL*Loader for Oracle, BCP utility for MSSQL), and then &lt;/P&gt;&lt;P&gt;c) deletes the CSV files&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How you manage the credentials for BCP or SQL*Lite is up to you, really, probably best handled with credential-provider (CP). The builtin SQL import option simply uses BCP and relies on integrated windows credentials afaik, which is why it only works for on-premises SQL servers.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You may find difficulties when the data that EVD pulls contains newline characters, or a mixture of commas and double-quotes (description fields can contain such data, and reason fields). I spent some time designing truly reliable import routines for Oracle or MSSQL, the best tip I would give is to use a multi-character field delimeter such as ##!!## to ensure you get really unique data - but even then I found I sometimes needed to run a bit of code on the CSV files to fix them up before they would reliably import SQL*Loader or BCP - and considering getting a database tech with experience of bulk-imports to get the job done properly.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
    <pubDate>Wed, 27 Nov 2024 15:10:21 GMT</pubDate>
    <dc:creator>Jon_Musker</dc:creator>
    <dc:date>2024-11-27T15:10:21Z</dc:date>
    <item>
      <title>How to integrated EVD with Databases in Cloud (AWS &amp; Azure)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297303#M1408</link>
      <description>&lt;P&gt;Hi Everyone.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Need some help with integration of EVD with Cloud DBs. We are trying to implement EVD to export the data from CyberArk Vault and import that to the Database in Cloud (AWS &amp;amp; Azure)?&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We reviewed the CyberArk documentation for EVD implementation, however we didn't find the option to export the data to Cloud Database as the documentation says we have to run the PowerShell script using the same Domain user that has access to Database too. Also CyberArk recommend to run EVD and DB on the same server which is not a great approach when things are moving to the Cloud.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;I want to understand how we can upload the data to MS SQL database in AWS RDS with Local DB Cred.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Appreciate if you can point us to the right documentation or provide us steps to do that.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;We went through these docs already.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A alt="https://community.cyberark.com/s/article/Export-Vault-Data-Quick-Start" href="https://community.cyberark.com/s/article/Export-Vault-Data-Quick-Start" target="_blank"&gt;https://community.cyberark.com/s/article/Export-Vault-Data-Quick-Start&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&lt;A alt="https://docs.cyberark.com/pam-self-hosted/14.2/en/content/pas%20inst/evd-install.htm" href="https://docs.cyberark.com/pam-self-hosted/14.2/en/content/pas%20inst/evd-install.htm" target="_blank"&gt;https://docs.cyberark.com/pam-self-hosted/14.2/en/content/pas%20inst/evd-install.htm&lt;/A&gt;&lt;/P&gt;</description>
      <pubDate>Mon, 18 Nov 2024 19:01:32 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297303#M1408</guid>
      <dc:creator>Rauti</dc:creator>
      <dc:date>2024-11-18T19:01:32Z</dc:date>
    </item>
    <item>
      <title>Re: How to integrated EVD with Databases in Cloud (AWS &amp; Azure)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297304#M1409</link>
      <description>&lt;P&gt;For any advanced configuration of EVD I recommend creating your own scripts that &lt;/P&gt;&lt;P&gt;a) retrieves the relevant datasets to CSV files using EVD, and then &lt;/P&gt;&lt;P&gt;b) uploads the CSV files to tables in your database using an appropriate command-line ETL for the database provider of your choice (eg SQL*Loader for Oracle, BCP utility for MSSQL), and then &lt;/P&gt;&lt;P&gt;c) deletes the CSV files&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;How you manage the credentials for BCP or SQL*Lite is up to you, really, probably best handled with credential-provider (CP). The builtin SQL import option simply uses BCP and relies on integrated windows credentials afaik, which is why it only works for on-premises SQL servers.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;You may find difficulties when the data that EVD pulls contains newline characters, or a mixture of commas and double-quotes (description fields can contain such data, and reason fields). I spent some time designing truly reliable import routines for Oracle or MSSQL, the best tip I would give is to use a multi-character field delimeter such as ##!!## to ensure you get really unique data - but even then I found I sometimes needed to run a bit of code on the CSV files to fix them up before they would reliably import SQL*Loader or BCP - and considering getting a database tech with experience of bulk-imports to get the job done properly.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;</description>
      <pubDate>Wed, 27 Nov 2024 15:10:21 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297304#M1409</guid>
      <dc:creator>Jon_Musker</dc:creator>
      <dc:date>2024-11-27T15:10:21Z</dc:date>
    </item>
    <item>
      <title>Re: How to integrated EVD with Databases in Cloud (AWS &amp; Azure)</title>
      <link>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297305#M1410</link>
      <description>&lt;P&gt;Hi @Vivek Rautela​&amp;nbsp;&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;It seems that Jon Musker provided an answer to your question. Could you kindly let us know if this solution helped?&lt;/P&gt;&lt;P&gt;If so, please mark the answer as 'Select as Best' to assist other community members.&lt;/P&gt;&lt;P&gt;&amp;nbsp;&lt;/P&gt;&lt;P&gt;Thank you, Liad&lt;/P&gt;</description>
      <pubDate>Thu, 28 Nov 2024 13:46:39 GMT</pubDate>
      <guid>https://live.paloaltonetworks.com/t5/pam-self-hosted-discussions/how-to-integrated-evd-with-databases-in-cloud-aws-azure/m-p/1297305#M1410</guid>
      <dc:creator>CyberArkAlumni</dc:creator>
      <dc:date>2024-11-28T13:46:39Z</dc:date>
    </item>
  </channel>
</rss>

