設定Vertica Analytics的存取權 configure-fda-vertica

Last update: Fri Jul 19 2024 00:00:00 GMT+0000 (Coordinated Universal Time)

主題：

使用Campaign 同盟資料存取 (FDA)選項來處理儲存在外部資料庫中的資訊。請依照下列步驟設定Vertica Analytics的存取權。

在CentOS、Windows或Debian上設定Vertica Analytics
在Campaign中設定Vertica Analytics 外部帳戶

CentOS上的Vertica Analytics vertica-centos

若要在CentOS上設定Vertica Analytics，請遵循下列步驟：

下載Vertica Analytics的ODBC驅動程式。按一下這裡下載最新的Linux RPM。

然後，您需要使用以下命令安裝unixODBC：

code language-none
`yum search unixODBC yum install unixODBC.x86_64`

如果您先前已安裝Vertica Analytics伺服器，則會已經安裝ODBC驅動程式。在此情況下，請依照下列步驟更新磁碟機：

code language-none

code language-none
#Switch to root sudo su #Install the package (add --force to update it) rpm -Uvh vertica-client-x.x.x-x.x86_64.rpm [--force] #Open odbcinst.ini vi /etc/odbcinst.ini #Add a section for Vertica Analytics and save [VerVertica Analyticstica] Description = Vertica Analytics ODBC Driver Driver = /opt/vertica/lib64/libverticaodbc.so #Open odbc.ini vi /etc/odbc.ini #Add your DSN in ODBC Data Sources section, for example: [ODBC Data Sources] VMart = "VMart database on Vertica Analytics" #Add a DSN definition section below, for example: [VMart] Description = Vmart Database Driver = Vertica Analytics Database = VMart Servername = # The name of the server where Vertica Analytics is installed. Use localhost if Vertica Analytics is installed on the same machine. UID = dbadmin PWD = <password> Port = 5433 #Cleanup #Remove the ODBC package rm vertica-client-x.x.x-x.x86_64.rpm

#Switch to root
sudo su

#Install the package (add --force to update it)
rpm -Uvh vertica-client-x.x.x-x.x86_64.rpm [--force]

#Open odbcinst.ini
vi /etc/odbcinst.ini

#Add a section for Vertica Analytics and save
[VerVertica Analyticstica]
Description = Vertica Analytics ODBC Driver
Driver = /opt/vertica/lib64/libverticaodbc.so

#Open odbc.ini
vi /etc/odbc.ini

#Add your DSN in ODBC Data Sources section, for example:
[ODBC Data Sources]
VMart = "VMart database on Vertica Analytics"

#Add a DSN definition section below, for example:
[VMart]
Description = Vmart Database
Driver = Vertica Analytics
Database = VMart
Servername = # The name of the server where Vertica Analytics is installed. Use localhost if Vertica Analytics is installed on the same machine.
UID = dbadmin
PWD = <password>
Port = 5433

#Cleanup
#Remove the ODBC package
rm vertica-client-x.x.x-x.x86_64.rpm

然後，您可以在Adobe Campaign中設定Vertica Analytics外部帳戶。如需如何設定外部帳戶的詳細資訊，請參閱本節。

Windows上的Vertica Analytics vertica-windows

下載適用於Windows🔗的ODBC驅動程式。若要安裝適用於Windows的驅動程式，您必須啟用.NET Framework 3.5，否則安裝精靈會嘗試自動啟用並下載驅動程式。
在Windows中設定ODBC驅動程式。如需詳細資訊，請參閱此頁面
然後，您可以在Adobe Campaign中設定Vertica Analytics外部帳戶。如需如何設定外部帳戶的詳細資訊，請參閱本節。

在Debian上的Vertica Analytics vertica-debian

下載Vertica Analytics的ODBC驅動程式。按一下這裡開始下載。

然後，您需要使用以下命令安裝unixODBC：

code language-none
`apt-get install unixODBC`

如果您先前已安裝Vertica Analytics伺服器，則會已經安裝ODBC驅動程式。在此情況下，請依照下列步驟更新磁碟機：

code language-none

code language-none
#Switch to root sudo su #Move or copy the downloaded file and change to /root mv vertica_9.3..xx_odbc_x86_64_linux.tar.gz / cd / #Uncompress the file you downloaded tar vzxf vertica_9.3..xx_odbc_x86_64_linux.tar.gz #Remove the tar.gz since it is not needed anymore rm vertica_9.3..xx_odbc_x86_64_linux.tar.gz #Open odbcinst.ini vi /etc/odbcinst.ini #Add a section for Vertica Analytics and save [Vertica Analytics] Description = Vertica Analytics ODBC Driver Driver = /opt/vertica/lib64/libverticaodbc.so #Open odbc.ini vi /etc/odbc.ini #Add your DSN in ODBC Data Sources section, for example: [ODBC Data Sources] VMart = "VMart database on Vertica Analytics" #Add a DSN definition section below, for example: [VMart] Description = Vmart Database Driver = Vertica Analytics Database = VMart Servername = # The name of the server where Vertica Analytics is installed. Use localhost if Vertica Analytics is installed on the same machine. UID = dbadmin PWD = <password> Port = 5433

#Switch to root
sudo su

#Move or copy the downloaded file and change to /root
mv vertica_9.3..xx_odbc_x86_64_linux.tar.gz /
cd /

#Uncompress the file you downloaded
tar vzxf vertica_9.3..xx_odbc_x86_64_linux.tar.gz

#Remove the tar.gz since it is not needed anymore
rm vertica_9.3..xx_odbc_x86_64_linux.tar.gz

#Open odbcinst.ini
vi /etc/odbcinst.ini

#Add a section for Vertica Analytics and save
[Vertica Analytics]
Description = Vertica Analytics ODBC Driver
Driver = /opt/vertica/lib64/libverticaodbc.so

#Open odbc.ini
vi /etc/odbc.ini

#Add your DSN in ODBC Data Sources section, for example:
[ODBC Data Sources]
VMart = "VMart database on Vertica Analytics"

#Add a DSN definition section below, for example:
[VMart]
Description = Vmart Database
Driver = Vertica Analytics
Database = VMart
Servername = # The name of the server where Vertica Analytics is installed. Use localhost if Vertica Analytics is installed on the same machine.
UID = dbadmin
PWD = <password>
Port = 5433

然後，您可以在Adobe Campaign中設定Vertica Analytics外部帳戶。如需如何設定外部帳戶的詳細資訊，請參閱本節。

Vertica Analytics外部帳戶 vertica-external

您必須建立Vertica Analytics外部帳戶，才能將Campaign執行個體連線至Vertica Analytics外部資料庫。

從行銷活動 Explorer，按一下 Administration '>' Platform '>' External accounts。
按一下 New。
選取 External database 作為外部帳戶的 Type。
設定 Vertica Analytics 外部帳戶，您必須指定：
- Type： Vertica Analytics
- Server： Vertica Analytics伺服器的URL
- Account：使用者名稱
- Password：使用者帳戶密碼
- Database：資料庫的名稱

聯結器支援下列選項：

選項

說明

時區名稱

預設為空白，這表示會使用Campaign Classic應用程式伺服器的系統時區。選項可用來強制TIMEZONE工作階段引數。

recommendation-more-help

601d79c3-e613-4db3-889a-ae959cd9e3e1