Ruths.ai Product Support

The purpose of this article is to explain provide an overview of Writing to ARIES

REQUIREMENTS Before Using The ARIES Connector. 

• 64 bit Office Product
• Database Compatible Driver
  Example - To get Aries Connector to be compatible with both OLEDB drivers (64 bit and 32 bit)
  

  MS Office	OLEDB Database Engine	ODBC Driver Version	Download Link	File Name
  Office 64 bit	2010 64 bit and 2007 32 bit See the download link	12.0	2010 64 bit https://www.microsoft.com/en-us/download/details.aspx?id=13255 2007 32 bit https://www.microsoft.com/en-us/download/details.aspx?id=23734	AccessDatabaseEngine_X64.exe AccessDatabaseEngine.exe

Steps: 

1. Ensure that you have a 64 bit Office Product
2. Download 2010 64 bit driver in the download link
3. Download 2007 32 bit driver in the download link

After these drivers are installed, the Aries Connector(64 bit) and Aries Database(64,32) can now be compatible with both drivers. 

The ARIES Connector manages inputs and outputs of ARIES wells, production, and declines to the Petro.ai Database.

In this article, we will step through an example of how to Write to ARIES from a Petro.ai Database. 

How to Write to ARIES 

1. On the ARIES Connector, select Write to ARIES
   
2. In the ARIES Connection option, input the Connection String.
   Note: This is the path for the ARIES Database Provider.
   Example of a connection string:
   
   
3. Use the drop-down, and choose the Connection String Provider (OleDB, SQLServer, ODBC)
   
4. Click Test Connection (ARIES Connection).
   Note: If using OleDB and you experience this error: "The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered", you will need to download and install the 64-bit version of Microsoft Access Database Engine 2010 Redistributable which can be downloaded from Microsoft's site here.
   
   
5. Input the Schema Name (Optional)
   
6. Scroll through the AC_ECONOMIC, AC_PROPERTY, AC_PRODUCT, AC_SCENARIO tabs and configure the column mapping.
   
7. In the Petro.ai dropdown, select your Petro.ai Database.
   Note: If a Petro.ai Database is not set up see Configure MongoDB for Spotfire in Administration Manager.
   Note: Your company's available connection will differ.
   
8. Click Test connection (Petro.ai).
   
9. Click Load
   
10. The Panel below will populate with the scenarios/qualifiers that were pulled from Petro.ai Database.
    
11. Select a scenario/qualifier from the panel.
    
12. Select the Job Options (optional).
    
13. Click Run Job.
    Note: This will run the job script with the given parameters set from the ARIES Connector.
    The ARIES Connector Output panel will display details of the Job process.
    
14. Once complete, close out the ARIES Connector Output.

For additional information on ARIES Connector documentation, click here.