Note

Please skip this section if you are using the supplied Docker image with the entire Persephone software stack.

By default, PersephoneShell can work with Oracle and MySQL (MariaDb) databases.

The Oracle 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 a 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.