This documentation page assumes that you already have a SeekTable account. You can create free account by signing up.

Oracle connection for pivot table reports

Oracle Database can be used as a data source with SQL-compatible database connector.

Connection String should be a valid connection string for .NET Oracle Data Provider; for example:

Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=hostName)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=serviceName)));User Id=user;Password=password;
HOST Specifies the host name of the machine on which the Oracle Database is running.
Do not use "localhost" or LAN server name; use only public IP address or server's domain name.
SERVICE_NAME specifies the name of the database service.
User Id Oracle user name. It is recommended to create special user with read-only rights.
Password Password for the user specified by User Id.