# Create a data source with Okta Procedure: Enable the Database Tools and SQL plugin This functionality relies on the Database Tools and SQL plugin, which is bundled and enabled in IntelliJ IDEA by default. If the relevant features are not available, make sure that you did not disable the plugin. > **Note:** > Database Tools and SQL functionality support is limited in IntelliJ IDEA without the Ultimate subscription. 1. Press `Ctrl+Alt+S` (Windows), `⌘ Comma` (macOS), `⌘ Comma` (IntelliJ IDEA Classic (macOS)), `⌘ Comma` (macOS System Shortcuts), `Ctrl+Alt+S` (XWin), `Ctrl+Alt+S` (GNOME), `Ctrl+Alt+S` (KDE), `Ctrl+Alt+S` (Emacs), `Ctrl+Alt+S` (Sublime Text), `⌘ Comma` (Sublime Text (macOS)), `Ctrl+Alt+S` (NetBeans), `Ctrl+Alt+S` (Visual Studio), `⌘ Comma` (Visual Studio (macOS)), `Ctrl+Alt+S` (Eclipse), `⌘ Comma` (Eclipse (macOS)) to open settings and then select `Plugins`. 2. Open the Installed tab, find the Database Tools and SQL plugin, and select the checkbox next to the plugin name. Procedure: Official documentation * For full information about Amazon Redshift, refer to [the official documentation](https://docs.aws.amazon.com/redshift/index.html). * For more versions of Amazon Redshift JDBC driver, refer to [the official JDBC driver downloads](https://docs.aws.amazon.com/redshift/latest/mgmt/jdbc20-download-driver.html). * [Amazon Redshift identity federation with multi-factor authentication](https://aws.amazon.com/blogs/big-data/amazon-redshift-identity-federation-with-multi-factor-authentication/) In this tutorial, we will create an Amazon Redshift data source, configure it to use SAML authentication with Okta identity provider, and run a test connection to a database. For more information about the integration and connection settings, refer to the following page: [Authentication at Okta Docs](https://help.okta.com/oie/en-us/content/topics/security/security_at_okta.htm). ## Prerequisites * Your Amazon Redshift dashboard must have a Amazon Redshift cluster in it. For more information about the Amazon Redshift cluster, refer to [Getting Started with Amazon Redshift.](https://docs.aws.amazon.com/redshift/latest/gsg/getting-started.html) * [AWS SSO](https://docs.aws.amazon.com/singlesignon/latest/userguide/what-is.html) has to be enabled for your AWS account. * Your AWS account has to be [linked to your Okta account](https://docs.aws.amazon.com/singlesignon/latest/userguide/tutorials.html). * Before connecting to a Amazon Redshift database with Okta SSO authentication , make sure to install and set up the [Okta Verify](https://help.okta.com/en-us/content/topics/mobile/okta-verify-overview.htm) application first. Once the required software is set up and ready , you need to create a Amazon Redshift data source in IntelliJ IDEA and configure it to use it with Okta SSO authentication. Procedure: Create a data source 1. In the Database tool window , click ![the New icon](https://resources.jetbrains.com.cn/help/img/idea/2026.2/app.expui.general.add.svg) New on the toolbar and navigate to `Data Source | Amazon Redshift`. ![Select the Amazon Redshift data source](https://resources.jetbrains.com.cn/help/img/idea/2026.2/create_new_data_source_redshift.png) 2. Check if there is a Download missing driver files link at the bottom of the connection settings area. Click this link to download drivers that are required to interact with a database. For a direct download link, refer to the [JetBrains JDBC drivers](https://www.jetbrains.com.cn/en-us/datagrip/jdbc-drivers/) page. ![The Download missing driver files link](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_connection_download_missing_drivers_link.png) 3. Specify the database connection details. 1. In the Host field, type the URL to connect to your Redis account with. For example, `examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com`. 2. In the Port field, type the port number. In our case, it is `5439`. 3. In the User field, type the email address you use to log in to your Okta account. 4. In the Password field, type your Okta account password. 5. In the Database field, type the database name to which you want to connect. In our case, the database is `dev`. 6. To the end of autogenerated URL in the JDBC URL field, add `?` and the following properties separated with `&`: * `plugin_name=`: the [SAML-based credential provider plugin](https://docs.aws.amazon.com/redshift/latest/mgmt/options-for-providing-iam-credentials.html#using-credentials-provider-plugin) you use for authentication. In this tutorial, we will use the Browser SAML plugin that can work with SAML-based identity providers: `plugin_name=com.amazon.redshift.plugin.BrowserSamlCredentialsProvider`. * `login_url=`: the identity provider URL. In our case, it is the URL to the Okta login page: `login_url=https://example.okta.com/app/example_1/abc012/sso/saml` . So, our JDBC URL is as follows: `jdbc:redshift:iam://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev?plugin_name=com.amazon.redshift.plugin.BrowserSamlCredentialsProvider&login_url=https://example.okta.com/app/example_1/abc012/sso/saml` Alternatively, type your JDBC URL in the URL field. The general URL to use is as follows: * Format: `jdbc:redshift:iam://...redshift.amazonaws.com:/dev?plugin_name=&login_url=&user=&password=` * Example: `jdbc:redshift:iam://examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com:5439/dev?plugin_name=com.amazon.redshift.plugin.BrowserSamlCredentialsProvider&login_url=https://example.okta.com/app/example_1/abc012/sso/saml&user=&password=` 4. Click the Test Connection link at the bottom of the connection details area to initiate a test connection to your database. ![Test Connection link](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_test_connection_link.png) 5. On the Okta website that opens in the browser, enter your user credentials and log in to your Okta account. ![Log in to your Okta account on the Okta website](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_redshift_okta_log_in_to_okta.png) 6. Once Okta confirms your identity, return to IntelliJ IDEA. ![Identity confirmation message from Okta](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_redshift_okta_verified.png) 7. In the IDE, click OK to save your new data source. ![Database connection details](https://resources.jetbrains.com.cn/help/img/idea/2026.2/db_connection_details_redshift_okta.png) ## See also ### Reference [Data sources and their elements](database-tool-window.html#icons-for-data-sources-and-their-elements) [Data Sources and Drivers dialog](data-sources-and-drivers-dialog.html) ### Tool Windows [Database tool window](database-tool-window.html)