Long: to use an extended JDBC URL format with advanced parameters.įor the URL only connection type, the JDBC URL that you enter is used as is.įor the other connection types, the JDBC URL is broken down into connection details. TNS: to use tnsnames.ora configuration file. Service name: to use an alias to an Oracle instance (or many instances). SID: to use a unique name of an Oracle instance (a process that runs on the workstation). For more information about driver types, refer to Oracle JDBC FAQ.įrom the Connection type list, select the connection type depending on the connection details that you have: In the General tab of Data Sources and Drivers dialog right pane, specify the driver and connection type.įrom the Driver list, select the JDBC driver for your connection.įor Oracle, the supported drivers are Oracle and Oracle for 9.X, 10.X, 11.1. Navigate to Data Source and select Oracle. In the Database Explorer ( View | Tool Windows | Database Explorer), click the New icon ( ) in the toolbar. You can do this using one of the following ways:įrom the main menu, navigate to File | New | Data Source and select Oracle. To connect to the database, create a data source that will store your connection details. For example, if you want to run a database on your machine and connect to that database, the corresponding DBMS software must be installed on the machine first. It is assumed that you already have the necessary prerequisites and the database is up and running. This topic presents a general procedure on how you can create a data source for the connection to your Oracle database in DataGrip, and run a test connection. To download Oracle database software, refer to the official software downloads.įor more versions of Oracle JDBC driver, refer to the official JDBC driver downloads. Official documentation and softwareįor full information about Oracle, refer to the official documentation. Only after that you will see the DataGrip interface and will be able to create connections. You need to create and open a project from the Welcome Screen.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |