Outcode User Guide
Developers GuideSales Contacts
English
English
  • WHAT IS OUTCODE?
    • Introduction
    • Getting Start
    • FAQ (3 Minutes)
    • Differences
  • Apps
    • API
      • Actions
        • HTTP Request
      • Trouble Shootings
    • JavaScript
      • Actions
        • Function Execution
      • Trouble Shootings
    • Data Source
      • MySQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • PostgreSQL
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MongoDB
        • Connection
        • Actions
          • Find Documents
          • Aggregation
          • Insert Single Document
          • Update Single Document
          • Delete Single Document
        • Trouble Shootings
      • Airtable
        • Connection
        • Actions
          • Webhook trigger
          • Insert a row
          • Get rows
          • Update a row
        • Trouble Shootings
      • Firebase Realtime Database
        • Connection
        • Actions
          • Insert a document
          • Get documents
          • Update a document
          • Delete a document
      • Google Sheets
        • Connection
        • Actions
          • Insert a row
          • Get rows
          • Delete a row
      • SQL Server (MS-SQL)
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • MariaDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Amazon Redshift
        • Connection
        • Actions
          • Query Execution
          • Get Query Status
          • Get Query Results
        • Trouble Shootings
      • Oracle Database
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redash
        • Connection
        • Actions
          • Create a query
          • Update a query
          • Delete a query
          • Get query result
          • Create a query job
          • Get a job result
          • Get query result by query result ID
        • Trouble Shootings
      • Microsoft Office365 Excel
        • Connection
        • Actions
          • Get rows
        • Trouble Shootings
      • CockroachDB
        • Connection
        • Actions
          • Query
        • Trouble Shootings
      • Redis
        • Connection
        • Actions
          • Get all keys
          • Get value by key
          • Search a key
          • Save the key
          • Save the key with set expiration
          • Append
          • Get exists key result
          • Get expiration count of key
          • Decrease the value
          • Increase the value
          • Delete a key
          • Flush all
    • Mail
      • SendGrid
        • Connection
        • Actions
          • Sends an Email
      • Amazon SES (Simple Email Service)
        • Connection
        • Actions
          • Sends an Email
        • Trouble Shootings
      • Gmail
        • Connection
        • Actions
          • Sends an Email
      • Stibee
        • Connection
        • Actions
          • Send Email by Trigger
          • Add a Subscriber
          • Remove a Subscriber
          • Unsubscribe a Subscriber
          • Assign the Subscriber to a Group
          • Release the Subscriber from a Group
      • Mailchimp
        • Connection
        • Actions
          • Campaign Delivery
          • Adds or Updates a Subscriber
          • Deletes a Subscriber
      • Mandrill (Mailchimp Transactional)
        • Connection
        • Actions
          • Sends an Email
          • Template Delivery
      • Mailgun
        • Connection
        • Actions
          • Sends an Email
      • Microsoft Office365 Outlook
        • Connection
        • Actions
          • Retrieves Messages from Mailfolder
          • Sends an Email
    • Message
      • Slack
        • Connection
        • Actions
          • Send a Message to Channel
          • Send a Direct Message to User
      • Microsoft Teams
        • Connection
        • Actions
          • Post a Message
      • Jandi
        • Connection
        • Actions
          • Send a Message
      • Twilio
        • Connection
        • Actions
          • Sends a SMS
      • OneSignal
        • Connection
        • Actions
          • Send message by segment
      • Solapi
        • Connection
        • Actions
          • Sends a SMS
          • Sends a LMS
          • Sends a MMS
          • Sends a Kakao Alimtalk
          • Sends a Kakao FriendTalk
          • Sends a Kakao FriendTalk (Button Type)
          • Retrieve Sending History
          • Retrieve Blacklist
        • Trouble Shootings
      • Lark
        • Connection
        • Actions
          • Send a text message via Custom Bot
          • Send a interactive message via Custom Bot
      • Discord
        • Connection
        • Actions
          • Guild (Server)
            • Get Bot Guilds
            • Get Guild Channels
            • List Guild Members
            • Search Guild Members
            • Get Guild Roles
            • Add Guild Member Role
            • Remove Guild Member Role
            • Get Guild Bans
            • Create Guild Ban
            • Remove Guild Ban
          • Message
            • Create Channel Message
            • Create Direct Message
          • Guild Scheduled Event
            • List Scheduled Events for Guild
            • Create Guild Scheduled Event
            • Get Guild Scheduled Event Users
    • Productivity
      • Google Calendar
        • Connection
        • Actions
          • Get Events
          • Insert a Event
      • Naver Open API
        • Connection
        • Actions
          • Retrieves News
          • Retrieves Trend Index
          • Retrieves Blog Posts
      • Typeform
        • Connection
        • Actions
          • Webhook Trigger
          • Retrieve Responses
      • Calendly
        • Connection
        • Actions
          • Webhook Trigger
          • Create a Single Link
      • Octoparse
        • Connection
        • Actions
          • Get Data by Offset
      • Microsoft Excel (.xlsx File)
        • Connection
        • Actions
          • Get Rows
      • Naver works
        • Connection
        • Actions
          • Retrieves Mails
          • Sends Email
          • Send a Message To Channel
          • Send a Direct Message To User
      • Notion
        • Connection
        • Actions
          • Retrieves Rows
          • Retrieves Rows with Filter
          • Create a Row
          • Update a Row
      • Korea Data API Center
        • Connection
        • Actions
          • FSC API
          • Others API
      • Microsoft OneDrive
        • Connection
        • Actions
          • Retrieves Files
      • Jira Cloud
        • Connection
        • Actions
          • Get Issues by Project
          • Get Issues by Board
          • Get Issues by Sprint
          • Create Issue
          • Create Issue Comment
          • Edit Issue
          • Delete Issue
      • Webflow
        • Connection
        • Actions
          • Get Form Responses
      • Modusign
        • Connection
        • Actions
          • Get Documents
          • Get Templates
          • Request Sign Using a Template
          • Request Send a Reminder
          • Cancel a Sign Request
          • Change Signing Due
        • Trouble Shootings
      • Google Analytics 4
        • Connection
        • Actions
          • Run Report
          • Realtime Report
      • Google Tasks
        • Connection
        • Actions
          • Get Tasklists
          • Create a Tasklist
          • Update a Tasklist
          • Delete a Tasklist
          • Get Tasks
          • Create a Task
      • Google Forms
        • Connection
        • Actions
          • Get Form Responses
      • Microsoft To Do
        • Connection
        • Actions
          • Tasklist
            • Create a Tasklist
            • Get Tasklists
            • Update a Tasklist
            • Delete a Tasklist
          • Task
            • Get Tasks
            • Create a Task
            • Update a Task
            • Delete a Task
          • Checklist
            • Get Checklist
            • Create a Checklist Item
            • Update a Checklist Item
            • Delete a Checklist Item
      • RSS
        • Connection
        • Actions
          • Get RSS Feed
    • SNS
      • LinkedIn
        • Connection
        • Actions
          • Post a Text Article
          • Post a Share Article
    • Advertisement
      • Meta(Facebook) Business Center
        • Connection
        • Actions
          • Get Leads
          • Ad Account Insights
          • Campaign Insights
          • Adset Insights
          • Ad Insights
        • Trouble Shootings
      • NAVER Search Ads
        • Connection
        • Actions
          • Campaign Stats
          • Adgroup Stats
          • Keyword Stats
          • Criterion Stats
      • Kakao Keyword Ads
        • Connection
        • Actions
          • View report on ad accounts
          • View reports on campaigns
          • View reports on ad groups
          • View reports on keywords
          • View reports on creatives
        • Trouble Shootings
      • Kakao Moment
        • Connection
        • Actions
          • View report on ad account
          • View reports on campaigns
          • View reports on ad groups
          • View reports on creatives
        • Trouble Shootings
      • Google Ads
        • Connection
        • Actions
          • Campaign Insights
          • Ad Group Insights
          • Ad Group Ad Insights
          • GAQL Execution
    • ERP
      • ECOUNT ERP
        • Connection
        • Actions
          • New Customer/Vendor
          • New Item
          • New Purchase
          • New Quotation
          • New Sales
          • New Sales Order
          • Invoice II Auto Journal (Sales)
          • Invoice II Auto Journal (Purchase)
      • Pipedrive CRM
        • Connection
        • Actions
          • Activity
            • Get all activities assigned to a particular user
            • Add an activity
            • Delete an activity
          • Deals
            • Get all deals
            • List participants of a deal
            • List products attached to a deal
            • Add a deal
            • Duplicate deal
            • Add a participant to a deal
            • Add a Product To a Deal
            • Update a deal
            • Delete a deal
            • Delete a participant from a deal
            • Delete an attached product from a deal
          • Leads
            • Get all leads
            • Add a lead
            • Update a lead
          • Organizations
            • Get all organizations
            • Add an organization
            • Delete an organization
            • List mail messages associated with an organization
            • List followers of an organization
          • Persons
            • Get all persons
            • List products associated with a person
            • Add a person
            • Delete a person
          • Products
            • Get all products
            • Get deals where a product is attached to
            • List followers of a product
            • Add a product
            • Update a product
            • Delete a product
    • Commerce
      • Woo Commerce
        • Connection
        • Actions
          • Create a Coupon
          • List All Coupons
          • Update a Coupon
          • Delete a Coupon
          • Create a Customer
          • List All Customers
          • Update a Customer
          • Delete an User
          • List All Orders
          • Create a Product
          • List All Products
          • Update a Product
          • Duplicate Product
          • Delete a Product
          • Retrieve Sales Report
      • Imweb
        • Connection
        • Actions
          • Get All Coupons
          • Get All Inquires
          • Post a Inquiry Answer
          • Get All User
          • Get All Orders
          • Get All Products
          • Get All Reviews
    • AI
      • OpenAI API (ChatGPT)
        • Connection
        • Actions
          • Chat
            • Create Chat Completion
            • Get Chat Completion
            • Get Chat Messages
            • Get List Chat Completions
            • Update a Chat Completion
            • Delete a Chat Completion
          • Embedding
            • Create Embeddings
          • Moderation
            • Create Moderation
      • Anthropic (Claude)
        • Connection
        • Actions
          • Messages
          • Count Message Token
      • Google Gemini
        • Connection
        • Actions
          • Text Generation
          • Text Generation (Extended)
          • Counting Tokens
          • Embeddings
      • Perplexity
        • Connection
        • Actions
          • Chat Completions
      • xAI (Grok)
        • Connection
        • Actions
          • Chat completions
          • Get deferred chat completions
          • Tokenize text
  • Automation
    • Getting Start
    • Tips
      • Reference value assignment
      • How to use references
    • Running the app
      • Manual Execution Button
      • Schedule
    • Add Filters
      • Text, URL Filter
      • Number, Percentage, Currency Filter
      • Datetime Filter
    • Transform Type (Optional)
      • Text
      • Number
      • Percentage
      • Datetime
      • Currency
      • URL
  • Dataflow
    • Getting Start
    • Quickstart Guide
    • Reference value assignment
    • How to use
      • Manual Execution
      • Schedule
      • Webhook
  • Settings
    • Organization & Team
    • Run Count & Run History
    • Schedule Management
  • FAQ & Policy
    • Email Change Request
    • Pricing & Subscription Cancellation
    • Roles & Management
    • Secure Policies
      • Access Controls
      • Privacy Policy
      • Security Methods
Powered by GitBook
On this page

Was this helpful?

  1. Apps
  2. Data Source
  3. Amazon Redshift

Connection

Last updated 1 month ago

Was this helpful?

Field
Description
Comment

Region

Region(Location)

e.g.) ap-northeast-2

Access Key ID

Access Key ID issued by IAM

Refer to "How to get credentials" tab

Secret Access Key

Secret Access Key ID issude by IAM

  1. Go to the IAM menu and create a new user.

  1. Please proceed with the user settings as shown in the screen below.

  • Username: Specify the username for the user who will access the AWS Console.

  • Check the Provide user access to the AWS Management Console option.

  • For User type, select the I want to create an IAM user option.

  • The Console password can either be auto-generated or manually set by you.

  • Users must create a new password at next sign-in: Choose whether the newly created user should change their password upon first login.

  • Once all settings are complete, click the Next button.

  1. Specify the user's instance access permissions.

  • In the Permission Options, select Attach policies directly, which means you will use existing permissions.

  • Choose the AmazonRedshiftFullAccess policy.

  • Once the selection is complete, click the Next button.

  1. After verifying the permission settings, click the Create user button to create the new account.

  1. If the user is successfully created, a success modal will appear. Click the View User button on the right side of the modal to navigate to the detailed properties.

  1. Click the Create access key button to generate an Access Key for connecting to Outcode.

  1. Set the Access Key creation options according to the screen below, then click the Next button.

  • For Use case, select Command Line Interface (CLI).

  • Check the Confirmation box, then click the Next button.

  1. Enter a description (tag) for the Access Key, then click the Create access key button to generate the key.

  1. The Access Key required for creating the Outcode app has been generated. Once the page is navigated away from, the key cannot be retrieved again. Please copy it to a separate storage location or save it using the Download .csv file option below. Be sure to keep the issued Access Key secure and prevent it from being exposed to external parties.

Please verify if the created user and access key are activated.

If you have custom security settings on your network, please add the following IP address to your allowlist: IP Range: 34.64.62.217