配置对Vertica Analytics的访问权限 configure-fda-vertica

Last update: Tue Sep 10 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应用程序服务器的系统时区。选项可用于强制使用时区会话参数。

recommendation-more-help

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