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
BedrockMission!

Learn More

View all

Sign in to view all badges

Disable temp table creation for External FDA connections

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

11-10-2018

I am connecting to external SQL Servers using FDA. I need to run some basic filter criteria and pull the data. So I will be shared with a read only account and will not have any create table access.

So I am doing some groundwork and realized that the database connection made using FDA creates the temp workflow tables in the same way as the default database (example: wkf111329973_114_1). Then the data can be copied to the default database.

Is there a way I can instruct Adobe Campaign Classic just to ready the data instead of storing it into a temp table and then read and insert. Something that IBM Campaign (Unica) allows you to control

also does it try to create temp tables for Hadoop as well? I need to connect to Hortonwork Hive table for another requirement. I think even if I can get approval for the temp table for SQL Server, Hadoop will not allow any table creation into their space for sure.

Also is there any detailed documentation for external account which covers the advanced fields. Like what table and function prefix does? How does HTTP relay works? What are the functions created when you click on Deploy function and so on.

Really poor documentation covering only the basic stuffs

Accepted Solutions (0)

Answers (0)