Amazon Redshift Guide de l'utilisateur Page 158
- Page / 255
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
Database=database_name
locale=locale
The following example shows the configuration for odbc.ini on Linux operating systems:
[ODBC Data Sources]
Amazon_Redshift_x32=Amazon Redshift (x86)
Amazon_Redshift_x64=Amazon Redshift (x64)
[Amazon Redshift (x86)]
Driver=/opt/amazon/redshiftodbc/lib/32/libamazonredshiftodbc32.so
Host=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com
Port=5932
Database=dev
locale=en-US
[Amazon Redshift (x64)]
Driver=/opt/amazon/redshiftodbc/lib/64/libamazonredshiftodbc64.so
Host=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com
Port=5932
Database=dev
locale=en-US
Use the following format on Mac OS X operating systems:
[ODBC Data Sources]
dsn_name=driver_name
[dsn_name]
Driver=path/libamazonredshiftodbc.dylib
Host=cluster_endpoint
Port=port_number
Database=database_name
locale=locale
The following example shows the configuration for odbc.ini on Mac OS X operating systems:
[ODBC Data Sources]
Amazon_Redshift_dylib=Amazon Redshift DSN for Mac OS X
[Amazon Redshift DSN for Mac OS X]
Driver=/opt/amazon/redshift/lib/universal/libamazonredshiftodbc.dylib
Host=examplecluster.abc123xyz789.us-west-2.redshift.amazonaws.com
Port=5932
Database=dev
locale=en-US
Configuring the odbcinst.ini File
You use the odbcinst.ini file to define ODBC drivers.
API Version 2012-12-01
152
Amazon Redshift Management Guide
Configuring Connections in Amazon Redshift
- Amazon Redshift 1
- Table of Contents 3
- What Is Amazon Redshift? 7
- Cluster Management 8
- Cluster Access and Security 8
- Monitoring Clusters 9
- Databases 10
- Amazon Redshift Clusters 11
- About Clusters and Nodes 12
- Dense Storage Node Types 13
- Dense Compute Node Types 13
- Resizing a Cluster 14
- EC2-Classic Platform 15
- EC2-VPC Platform 15
- Maintenance Windows 16
- Default Disk Space Alarm 17
- Renaming Clusters 17
- Creating a Cluster 20
- Modifying a Cluster 26
- To modify a cluster 27
- Rebooting a Cluster 29
- Cloud (VPC) 38
- Creating a Cluster in a VPC 39
- Cluster Subnet Groups 43
- Amazon Redshift Parameter 62
- Result Set 63
- User Group Wildcard 68
- Query Group Wildcard 71
- Operating Systems 78
- Creating a Parameter Group 79
- Modifying a Parameter Group 80
- Deleting a Parameter Group 82
- SDK for Java 83
- Amazon Redshift Snapshots 88
- Manual Snapshots 89
- Sharing Snapshots 90
- Creating a Manual Snapshot 93
- Deleting a Manual Snapshot 94
- Copying an Automated Snapshot 94
- Sharing a Cluster Snapshot 97
- Snapshot Copy 99
- CLI and API 103
- Amazon Redshift Database 104
- Encryption 104
- Hardware Security Modules 105
- Creating an HSM Connection 106
- API Version 2012-12-01 107
- Deleting an HSM Connection 110
- Rotating Encryption Keys 111
- Redshift CLI and API 112
- Purchasing Amazon Redshift 113
- Reserved Nodes 113
- Amazon Redshift Console 114
- AWS SDK for Java 117
- Amazon Redshift CLI and API 120
- Controlling Access to Amazon 121
- Redshift Resources 121
- Management 122
- Example 3: Manage clusters 129
- Accessing Amazon Redshift 134
- Clusters and Databases 134
- Command Line 136
- Signing an HTTP Request 137
- Example Signature Calculation 138
- Installation Instructions 140
- Step 1: Before You Begin 141
- Step 2: Launch a Cluster 141
- Connecting to a Cluster 144
- Configure a JDBC Connection 146
- Configure an ODBC Connection 150
- Windows Operating Systems 152
- Important 154
- System Requirements 154
- Configuring the odbc.ini File 157
- Connect Using SSL 164
- Install SQL Workbench/J 168
- Redshift 179
- Set MTU on Mac OS X 183
- Monitoring Amazon Redshift 185
- Cluster Performance 185
- Amazon Redshift Metrics 186
- Redshift Console 189
- Cluster Metrics: Examples 191
- Terminating a Running Query 193
- Viewing Query Details 194
- Analyzing Query Execution 195
- Creating an Alarm 201
- CloudWatch Console 203
- Amazon Redshift Events 205
- Filtering Events 206
- Overview 208
- Messages 210
- Subscriptions 218
- Subscription 218
- Notification Subscription 219
- Database Audit Logging 221
- Connection Log 222
- User Log 222
- Enabling Logging 223
- Managing Log Files 224
- Prerequisites 233
- Step 1: Resize the Cluster 233
- Step 1:Take a Snapshot 235
- Limits in Amazon Redshift 243
- Naming Constraints 244
- Tagging Resources in Amazon 246
- Tagging Requirements 247
- To add tags to a resource 249
- Document History 251
Produits connexes et manuels pour Logiciel Amazon Redshift
Logiciel Amazon AWS SDK Guide de l'utilisateur
(155 pages)
(155 pages)
© 2020, manymanuals.fr. Tous droits réservés | 0.068 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels