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

Creating Databases and tables using SQL Commands

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

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

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

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

13-12-2017

Hi,

Can you create create AC databases and/or tables using SQL Commands? If so, how does one do so?

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Validate 1
MVP
Jean-Serge_Biro
MVP

Likes

353 likes

Total Posts

464 posts

Correct Reply

153 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 250
View profile
Jean-Serge_Biro
MVP

15-12-2017

Hi,

If your version is AC classic (v6/v7):

You can also do the invert thing: create tables directly with you RDBMS tool (SQL Server, Oracle, mySql, Postgresql, etc) then discovering them with the Adobe Campaign client software, menu Tools/Advanced/Database Extension Wizard, then select the table(s) in order to generate automatically the XML source schema with your customer namespace.


Then you have to adapt a bit the xml schema generated to add specific things such as dblinks for joins with other tables, etc.

There is also an admin menu tool for doing the same but at field level.

There are advantages (more powerful to master all the underlying RDBMS possibilities such as specific indexing/primary key/sequences/storage properties), but drawback is the availability of direct RDBMS access (or your database administrator) so probably reserved for On Premise hosting configurations.

Regards
J-Serge

Answers (2)

Answers (2)

Avatar

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

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

Avatar
Validate 1
Employee
RamaRajesh
Employee

Likes

40 likes

Total Posts

81 posts

Correct Reply

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

14-12-2017

Hi,

creating the data model and the tables- As far as i know, It is possible only by creating a schema (xml, which defines the structure of a table) and updating the database for this schema creates a table out of that. PostgreSQL is used to query the table

Anyone- Correct me, if i am wrong.

Thanks,

Rajesh

Avatar

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

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

Avatar
Validate 10
Level 3
jael91407431
Level 3

Likes

13 likes

Total Posts

46 posts

Correct Reply

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

02-01-2018

Super, thank you Serge. Will give it a try.

Much appreciated,

Jae