Creating Databases and tables using SQL Commands | Community
Skip to main content
J
jael91407431
Level 3
December 13, 2017
Solved

Creating Databases and tables using SQL Commands

  • December 13, 2017
  • 3 replies
  • 3151 views

Hi,

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

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
    Best answer by Jean-Serge_Biro

    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

    3 replies

    R
    Adobe Employee
    ramakattAdobe Employee
    Adobe Employee
    December 14, 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

      Jean-Serge_Biro
      Jean-Serge_BiroAccepted solution
      Level 10
      December 15, 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

        J
        jael91407431Author
        Level 3
        January 2, 2018

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

        Much appreciated,

        Jae

        Terms & ConditionsAccessibility statement

        Loading footer...