Amazon Redshift

Amazon Redshift is a fast, fully managed cloud data warehouse that makes it simple and cost-effective to analyze all your data using standard SQL and your existing Business Intelligence (BI) tools.

Connect to Amazon Redshift

OvalEdge Connector provides connectivity to the Redshift databases that enable you to connect and crawl the metadata from the Redshift databases. In this document, you can see how to establish a connection with your Amazon Redshift database. For more information about the Redshift API, visit their website -  https://docs.aws.amazon.com/redshift/latest/APIReference/Welcome.html

Before we begin

To connect to a Redshift database,

• The username and password you use to log into your Redshift database
• Hostname/IP address for the Redshift database server.
• The port number for the database (Differs if the Redshift is hosted in a different AWS region).
• Database name.
• Choose and add the right Redshift drivers into the OvalEdge Jar path to communicate to your Redshift database. Check the configuration section for further details on how to add the drivers to the jar path. Refer https://s3.amazonaws.com/redshift-downloads/drivers/jdbc/1.2.41.1065/RedshiftJDBC42-no-awssdk-1.2.41.1065.jar
  to download the Jar file.

Connection Details

Connect and Validate the Redshift from OvalEdge

1. Select the Administration tab and click the + button to expand the functions.
2. Select the Crawler.

3. Click the New Database from the Crawler window. The dialog box for configuring a database connection is displayed.

   Example:

      

4. Select the Database type in the drop-down menu.

5. Enter the connection details.

6. Click validate to test the database connection.

When validation completes, click save to finish the configuration of the reporting system connection.

Crawl the Connection

In OvalEdge, each database can be crawled at a Schema level. In other words, when there are multiple schemas within a database, you have an option to select a specific schema and crawl.

To crawl a specific Schema or multiple schemas:

1. Select the Administration tab and click the + button to expand the functions.
2. Select the Crawler.
3. Select a database from the list.
4. Click the Crawl/Profile button on the crawler page.
   The dialog box to select Important schema for crawling and Profiling is displayed.
   
        
        
5. Click the Checkbox next to the schema name and select a single schema or multiple schemas to crawl and profile.
6. To crawl all schemas, click Select All.
7. Click OK to initiate Crawling the database connection immediately.
   Alternatively, select Advanced options to schedule a Crawl and Profile action later. 
8. A dialog box displays that a crawl job is Initiated.
   
        
9. Select the Jobs tab in the object explorer (left side of window) to know the status of the job submitted.
10. Check the Job step status and click the Refresh button.
    
       
11. Go to the Crawl window to check the Last Crawl Status of the selected Schemas.