---
title: "Set up DataSync Agent to share to Oracle"
canonical: "https://docs.perspectium.com/space/helium/2113229/Set%20up%20DataSync%20Agent%20to%20share%20to%20Oracle"
format: markdown
---
You can configure your Perspectium DataSync Agent to share data from ServiceNow or Salesforce to an Oracle database by changing some additional  configurations in your  agent.xml  file . Prerequisites  First, you will need to  install the DataSync Agent  and  make sure that your agent.xml file is configured  correctly.  You will also need to  create a ServiceNow dynamic share/bulk share .   Make sure to  stop running your DataSync Agent  before making any Agent configuration changes.   Finally, you will need to create a database in Oracle that will store data replicated via the DataSync Agent.   NOTE :  The Agent can  partitioning and table compression  as long as there is enough storage in the  tablespace  and the table is created with the same primary keys as the Agent would create it (i.e. sys_id and any  temporal  fields if applicable). For any questions, contact  support@perspectium.com .   NOTE :  The Agent requires  six  open cursors  per ServiceNow table to be replicated as it uses prepared statements to ensure the most efficient processing possible. For each operation per table (insert, update, delete, query metadata) we use a prepared statement which is reused whenever the next similar operation needs to be executed against the same table. Each of these prepared statements uses a  cursor .  If we didn't use an open cursor, every transaction would be very inefficient because the Agent would need to re-establish the client/server connection and query the structure each time.  Procedure To set up your DataSync Agent to share application data to an Oracle database, follow these steps: