By default, PersephoneShell uses a managed driver for the Oracle database, known as ODP.NET (Oracle.ManagedDataAccess.dll). 

Tip

You can use MySQL (MariaDb is recommended) instead of Oracle. See the MySQL Documentation page for documentation on setting up MySQL servers.

The connection string can be provided in the following format:

Data Source=localhost:1521/orcl1;User ID=scott;Password=tiger

or as a more simplified string, known as EZCONNECT:

scott/tiger@localhost:1521/orcl1

The corresponding source in tnsname.ora would be

orcl=
  (DESCRIPTION=
    (ADDRESS=
      (PROTOCOL=TCP)
      (HOST=localhost)
      (PORT=1521)
    )
    (CONNECT_DATA=
      (SERVER=dedicated)
      (SERVICE_NAME=orcl1)
    )
  )

Regular connection strings will still work if tnsnames.ora is located in the program folder.

Data Source=orcl;User ID=scott;Password=tiger

Note

Use cipher utility to encode the connection string. In the encrypted form, it can be placed inside PersephoneShell configuration file.

In case MySql-compatible database is used, the connection string in the PersephoneShell configuration file should be accompanied by providerName, for example:

<add name="MYSQL" providerName="MySql.Data.MySqlClient" connectionString="---" />

In case the database contains massive data sets, it is recommended to change the default command timeout from 30 sec to a larger number. This value can be provided in the MariaDb connection string with the format such as this:

User Id=scott;Password=tiger;Host=localhost;Port=3306;Database=dev;Default Command Timeout=0

The value 0 means no limit on the duration of the command execution. Use this value with caution.