Database table

The Database table source allows you to connect to and import data from a relational database.

The connection details section of the panel allows you to select and connect to a Database. Omniscope supports a wide variety of different Databases. If your database isn't on the list then you should select ODBC or JDBC (Advanced).

After selecting a Database you need to configure the information required to connect to that database. Different databases require different sets of information. For example, when connecting to Microsoft SQL Server you should select a driver and the host, port, host (optional), database name (optional) and authentication information.

After entering the required connection information click on the 'Connect' button.  If there are any problems connecting to the database an error message will be displayed. Successfully connecting to the database a list of the tables available to import will be displayed in the Table selection dropdown.

Advanced users can choose to import data using a custom SQL statement rather than by simply selecting a table.