# Spring Boot integration with a differnet database

**URL:** <https://forum.flowable.org/t/spring-boot-integration-with-a-differnet-database/5993>\
**Category:** Flowable Engine\
**Created:** [May 11, 2020, 1:27pm UTC](https://forum.flowable.org/t/spring-boot-integration-with-a-differnet-database/5993 "2020-05-11T13:27:48Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![fiki574](https://yyz1.discourse-cdn.com/flex035/user_avatar/forum.flowable.org/fiki574/32/1675_2.png) [@fiki574](https://forum.flowable.org/u/fiki574)\
**Post date:** [May 11, 2020, 2:29pm UTC](https://forum.flowable.org/t/spring-boot-integration-with-a-differnet-database/5993/2 "2020-05-11T14:29:13Z")

</div>

Hey, here’s the solution that worked for me.

application.properties additions:

```
business.datasource.driver-class-name=org.postgresql.Driver
business.datasource.jdbc-url=jdbc:postgresql://192.168.0.1:5432/business
business.datasource.username=business
business.datasource.password=business
flowable.datasource.driver-class-name=org.postgresql.Driver
flowable.datasource.jdbc-url=jdbc:postgresql://192.168.0.2:5432/flowable
flowable.datasource.username=flowable
flowable.datasource.password=flowable

```

Datasource and transaction manager setup:

```
@Bean(name = "businessDataSource")
@Primary
@ConfigurationProperties(prefix = "business.datasource")
public DataSource primaryDataSource() {
  return DataSourceBuilder.create().build();
}

@Bean(name = "flowableDataSource")
@ConfigurationProperties(prefix = "flowable.datasource")
public DataSource secondaryDataSource() {
 return DataSourceBuilder.create().build();
}

@Bean(name = "flowableTransactionManager")
public PlatformTransactionManager transactionManager() {
DataSourceTransactionManager transactionManager = new DataSourceTransactionManager();
transactionManager.setDataSource(secondaryDataSource());
  return transactionManager;
}

```

Flowable configuration

```
@Autowired
@Qualifier("flowableDataSource")
private DataSource dataSource;

@Autowired
@Qualifier("flowableTransactionManager")
private PlatformTransactionManager transactionManager;

@Bean
public EngineConfigurationConfigurer<SpringAppEngineConfiguration> engineConfigurer() {
  return configuration -> {
    configuration.setDataSource(dataSource);
    configuration.setTransactionManager(transactionManager);
    configuration.setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_FALSE);
  };
}
```

---

_[View the full topic](https://forum.flowable.org/t/spring-boot-integration-with-a-differnet-database/5993)._