How many databases can each Data Store in Appian connect to?

In Appian, each Data Store can connect to only one database. This architecture is designed to ensure that the data management and access processes remain streamlined and efficient. By limiting the Data Store's connection to a single database, Appian helps to maintain data integrity and consistency, making it easier to manage relationships and queries without the complexity that comes from interfacing with multiple databases simultaneously.

The design choice also contributes to enhanced performance and simplifies configuration, as developers do not have to handle the complexities associated with multiple database connections within a single Data Store. While there are scenarios where applications may need to access data from multiple databases, this is typically handled through different Data Stores or using other integration techniques rather than attempting to connect multiple databases through a single Data Store.

This principle is why connecting to only one database is an essential aspect of how Data Stores function within the Appian framework.