Import Data from a JDBC Data Source
The Import Data from a JDBC Data Source page allows you to define a database connection configuration for nodes and links, then load your data.
- Click the New Configuration button to name a new database connection configuration.
- Specify a URL to connect to the database.
The Universal Resource Locator (URL) can indicate a connection to a remote database or a path to a local file.
It specifies the driver to use and the path to the file or database.
- Specify your user name and password, if these security items are required.
If your data is in a local file, you will not need to
enter a user name and password. If your data is in a database, the Database Administrator can provide the information.
- Specify an SQL query string for nodes (in the Nodes tab) and an SQL query string for links (in the Links tab).
If the database is an Excel file, you specify
the name of the sheet instead of a table name. The default sheet names in Excel are Sheet1, Sheet2, and so on.
- Click the Execute Query button to execute the SQL query.
- Click the Save Configuration button to store the database connection configuration for future use.
- Click Next.