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.