Communities
A collaborative platform to connect and grow with like-minded Informaticans across the globe
Product Communities
Connect and collaborate with Informatica experts and champions
Discussions
Have a question? Start a Discussion and get immediate answers you are looking for
User Groups
Customer-organized groups that meet online and in-person. Join today to network, share ideas, and get tips on how to get the most out of Informatica
Get Started
Community Guidelines
Knowledge Center
Troubleshooting documents, product guides, how to videos, best practices, and more
Knowledge Base
One-stop self-service portal for solutions, FAQs, Whitepapers, How Tos, Videos, and more
Support TV
Video channel for step-by-step instructions to use our products, best practices, troubleshooting tips, and much more
Documentation
Information library of the latest product documents
Velocity (Best Practices)
Best practices and use cases from the Implementation team
Learn
Rich resources to help you leverage full capabilities of our products
Trainings
Role-based training programs for the best ROI
Certifications
Get certified on Informatica products. Free, Foundation, or Professional
Product Learning Paths
Free and unlimited modules based on your expertise level and journey
Resources
Library of content to help you leverage the best of Informatica products
Tech Tuesdays Webinars
Most popular webinars on product architecture, best practices, and more
Product Availability Matrix
Product Availability Matrix statements of Informatica products
SupportFlash
Monthly support newsletter
Support Documents
Informatica Support Guide and Statements, Quick Start Guides, and Cloud Product Description Schedule
Product Lifecycle
End of Life statements of Informatica products
Ideas
Events
Change Request Tracking
Marketplace
中文
  • Informatica Data Quality 10.4.1
  • 所有产品

目录

Search

  1. 前言
  2. 命令行程序和实用程序
  3. 安装和配置命令行实用程序
  4. 使用命令行程序
  5. 命令行程序的环境变量
  6. 使用 infacmd
  7. infacmd as 命令引用
  8. infacmd aud 命令引用
  9. infacmd autotune 命令引用
  10. Infacmd bg 命令参考
  11. infacmd ccps 命令引用
  12. infacmd cluster 命令引用
  13. infacmd cms 命令引用
  14. infacmd dis 命令引用
  15. infacmd dp 命令引用
  16. infacmd idp 命令引用
  17. infacmd edp 命令引用
  18. Infacmd es 命令参考
  19. infacmd ihs 命令参考
  20. infacmd ipc 命令引用
  21. infacmd isp 命令引用
  22. infacmd ldm 命令引用
  23. infacmd mas 命令引用
  24. infacmd mi 命令引用
  25. infacmd mrs 命令引用
  26. infacmd ms 命令引用
  27. infacmd oie 命令引用
  28. infacmd ps 命令引用
  29. infacmd pwx 命令引用
  30. infacmd roh 命令引用
  31. infacmd rms 命令参考
  32. infacmd rtm 命令引用
  33. infacmd sch 命令参考
  34. infacmd search 命令引用
  35. infacmd sql 命令引用
  36. infacmd tdm 命令引用
  37. infacmd tools 命令引用
  38. infacmd wfs 命令引用
  39. infacmd ws 命令引用
  40. infacmd xrf 命令引用
  41. infacmd 控制文件
  42. infasetup 命令引用
  43. pmcmd 命令引用
  44. pmrep 命令引用
  45. 处理 pmrep 文件

Command Reference

Command Reference

上一个 下一个

Snowflake 连接选项

Snowflake 连接选项

使用连接选项定义 Snowflake 连接。
按以下格式输入连接选项：
... -o option_name=value option_name=value ...
例如， 
./infacmd.sh createconnection -dn Domain_Snowflake -un Administartor -pd Administrator -cn Snowflake_CLI -ct SNOWFLAKE -o "user=INFAADPQA password=passwd account=informatica role=ROLE_PC_AUTO  warehouse=QAAUTO_WH"
要输入多个选项，请使用空格将它们分隔开。要输入包含空格或其他非字母数字字符的值，请在该值两侧添加双引号。
下表介绍了 infacmd isp CreateConnection 和 UpdateConnection 命令必需的 Snowflake 连接选项：
属性
说明
connectionId
数据集成服务用来标识连接的字符串。
connectionType
连接类型。连接类型为 SnowFlake。
name
连接的名称。
account
Snowflake 帐户的名称。
additionalparam
使用以下格式输入一个或多个 JDBC 连接参数： 
<param1>=<value>&<param2>=<value>&<param3>=<value>....
例如： 
user=jon&warehouse=mywh&db=mydb&schema=public
password
连接到 Snowflake 帐户时使用的密码。
role
分配给用户的 Snowflake 角色。
user
连接到 Snowflake 帐户时使用的用户名。
warehouse
Snowflake 仓库名称。