Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

FDA connection to Mysql database

Avatar

Level 2

Hello Team,

 

We have a hybrid instance of Adobe campaign classic v7. The marketing instance is set up within our datacenter. For one of new use case we are trying to insert / update some data from adobe campaign to a Mysql db through FDA connection. We set up the following and validated.

#1. External account set for FDA connection to Mysql db. - tested and validated that the connection is successful.

#2. The user account used for the connection is a mysql db user (not a RHEL OS user with permission to unix file system on the db server) with permission to read / write / delete data in the table to which we want update data from adobe campaign.

 

When we tried to perform a simple update activity, the workflow fails with logs stating that LOCAL DATA LOCAL INFILE could not be executed.

 

writer2 WDB-200001 SQL statement 'LOAD DATA LOCAL INFILE '/tmp/mysql_bulk_pipe_21052_21052' INTO TABLE wkf9973818_100_1 CHARACTER SET latin1 (list of columns)' could not be executed.

 

Does this mean that there needs to be a ftp connection from adobe campaign server to the db server. 

and the user has to also have a write access to /tmp folder on the db server.

 

Please advise.

Thank you.

Regards,

Mahalingam P

0 Replies