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

Can't create external database

Avatar

Avatar
Validate 1
Level 2
james_icf
Level 2

Likes

9 likes

Total Posts

20 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
james_icf
Level 2

Likes

9 likes

Total Posts

20 posts

Correct Reply

2 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Affirm 1
View profile
james_icf
Level 2

30-01-2018

I have a fully on premise instance that is on running v.7. Campaign is installed on the same server that our data intended for campaign is located. It is an Oracle DB. However, I cannot create access to the external DB.

When I go to Tools>Advanced>Create database..., I get the database creation wizard. The Engine and Server are pre-populated with the correct information> I check the "use an existing database" option, and click next. The DB name is pre-populated and I enter the password, and click the below data character boxes and set the time zone. I don't change any of the packages checked (Delivery, marketing Campaigns (Campaign), and Access to External Data (Federated Data Access)), then click next. I check the box to "display and edit the SQL script for creating the tables". Leave the delete existing table box empty. Leave all following names default and add a name for the temp table name. I uncheck the "set or change password for Adobe 'admin' application account. When I click next, I get an error.

The error says -

Unknown schema 'xtk:srcSchema'.

Why is this happening? When I look into the data schems in the exlporer view, this schema exists.

Thank you

Replies

Avatar

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile

Avatar
Give Back 50
Level 10
florentlb
Level 10

Likes

237 likes

Total Posts

1,109 posts

Correct Reply

239 solutions
Top badges earned
Give Back 50
Give Back 5
Give Back 3
Give Back 25
Give Back 200
View profile
florentlb
Level 10

02-02-2018

Hi,

It's unclear to me if you want to use that database as Campaign database, or if you want to use it as an "external" database where you'd just access the data.

These 2 things are different in Campaign. For example, when creating an instance: see Creating and configuring the database ​or to simply create an external database access: see Accessing an external database

Hope this helps,

Florent