How can we change the prefix of tables

Camunda 7 Topics Discussion & Questions
1

how can we change the prefix of tables:
My bpm-platform file is here

<?xml version="1.0" encoding="UTF-8"?>
<bpm-platform xmlns="http://www.camunda.org/schema/1.0/BpmPlatform" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  xsi:schemaLocation="http://www.camunda.org/schema/1.0/BpmPlatform http://www.camunda.org/schema/1.0/BpmPlatform ">

  <job-executor>
    <job-acquisition name="default" />
  </job-executor>

  <process-engine name="default">
    <job-acquisition>default</job-acquisition>
    <configuration>org.camunda.bpm.engine.impl.cfg.StandaloneProcessEngineConfiguration</configuration>
    <datasource>java:jdbc/ProcessEngine</datasource>

    <properties>
	
      <property name="history">full</property>
      <property name="databaseSchemaUpdate">true</property>
      <property name="authorizationEnabled">true</property>
      <property name="jobExecutorDeploymentAware">true</property>
	  <!--<property name="databaseSchema">COGNI_</property>-->
	  <property name="databaseTablePrefix">COGNI_</property>
    </properties>

    <plugins>
      <!-- plugin enabling Process Application event listener support -->
      <plugin>
        <class>org.camunda.bpm.application.impl.event.ProcessApplicationEventListenerPlugin</class>
      </plugin>
      
      <!-- plugin enabling integration of camunda Spin -->
      <plugin>
        <class>org.camunda.spin.plugin.impl.SpinProcessEnginePlugin</class>
      </plugin>

      <!-- plugin enabling connect support -->
      <plugin>
        <class>org.camunda.connect.plugin.impl.ConnectProcessEnginePlugin</class>
      </plugin>

    <!-- LDAP CONFIGURATION -->
    <!-- Uncomment this section in order to enable LDAP support for this process engine -->
    <!-- Adjust configuration, see ( http://docs.camunda.org/latest/guides/user-guide/#process-engine-identity-service-the-ldap-identity-service ) -->

      <plugin>
        <class>org.camunda.bpm.identity.impl.ldap.plugin.LdapIdentityProviderPlugin</class>
        <properties>

          <property name="serverUrl">ldap://10.237.5.79:389/</property>
          <property name="acceptUntrustedCertificates">true</property>
          <property name="managerDn">CN=ETLdapUser,OU=ServiceAccounts,OU=India,OU=APAC,OU=Cognizant,DC=cts,DC=com</property>
          <property name="managerPassword">E111111#</property>

          <property name="baseDn"></property>

          <property name="userSearchBase">OU=Cognizant,DC=cts,DC=com</property>
          <property name="userSearchFilter">(objectclass=person)</property>

          <property name="userIdAttribute">mailNickname</property>
          <property name="userFirstnameAttribute">sAMAccountName</property>
          <!-- <property name="userLastnameAttribute">sn</property> -->
          <property name="userEmailAttribute">mail</property>
          <property name="userPasswordAttribute">userPassword</property>

          <property name="groupSearchBase">OU=Groups,OU=BTP,OU=Bangalore,OU=India,OU=APAC,OU=Cognizant,DC=cts,DC=com</property>
          <property name="groupSearchFilter">(objectclass=group)</property>
          <property name="groupIdAttribute">mailNickname</property>
          <property name="groupNameAttribute">sAMAccountName</property>

          <property name="groupMemberAttribute">member</property>
          <property name="groupMemberAttribute">managedBy</property>
          <property name="authorizationCheckEnabled">false</property>
        </properties>
      </plugin> 


      <!-- LDAP CONFIGURATION -->
      <!-- The following plugin allows you to grant administrator authorizations to an existing LDAP user -->
  
      <plugin>
        <class>org.camunda.bpm.engine.impl.plugin.AdministratorAuthorizationPlugin</class>
        <properties>
          <property name="administratorUserName">558735</property>
        </properties>
      </plugin>
   

    </plugins> 


  </process-engine>

</bpm-platform>

and my process.xml is

<?xml version="1.0" encoding="UTF-8" ?>

<process-application
    xmlns="http://www.camunda.org/schema/1.0/ProcessApplication"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

  <process-archive name="IDCS6-Generation">
   <process-engine>default</process-engine>
    <resource>IDCS6</resource>
   
    
   
 
    <properties>
      <property name="databaseSchema">COGNI_</property>
      <property name="isDeleteUponUndeploy">false</property>
      <property name="isScanForProcessDefinitions">true</property>
     
    </properties>
    
    
  </process-archive>

</process-application>
2

Hi @jauhari,

You can define your custom prefix in the databaseTablePrefix property in the process.xml. See the configuration properties documentation for the details and the most common configuration properties.

Best,
Johannes

3

@JoHeinem
Is there any changes required in bpm-platform file?
Do we also need to configure databaseschema property any where?

cheers,
Jauhari

4

Hi @jauhari,

Is there any changes required in bpm-platform file?

You can either set the property in the processes.xml or in the bpm-platform.xml. However, I would recommend to set the property in the latter.

Do we also need to configure databaseschema property any where?

I don’t know this property. Do you mean databaseSchemaUpdate maybe?

Best
Johannes

5