Follow the steps below to add tables from SQL Server, MySQL or Oracle:
- Navigate to Add Data and select the type of database you wish to connect to.
- In the connection window enter the server address and authentication properties. Click 'Connect to Server' to check the entered properties and get a list of databases available on that server. Select a database an click OK.
- In the database details window, select the tables you wish to add and click ADD to finish.
|
When the 'Automatically create relationships from database' option is enabled, table relations will be automatically created based on the Primary/Foreign key relationships defined in the database. Depending on the structure of your data, this may cause relationship cycles that may yield unexpected query results. Please see Handling Relationship Cycles from more details.
|
Supported Versions and Prerequisites
Database
| Supported Versions | Prerequisites |
SQL Server
| SQL Server 2000 and higher
| None
|
| MySQL | MySQL 5.0 and higher
| None |
| Oracle | Oracle 9i and higher
| Requires Oracle client connectivity components. You should be prompted for this installation automatically. A downloadable version is available here.
|