Skip to main content
pato0001
New Participant
Jun 13, 2023 10:40 PM UTC
Solved

MySQL Data Source Configuration

Setting up a new dev app on Appian Community Edition. Connecting to MySQL cloud database.

Receiving "Test Failed" error while trying to create MySQL Data Source as Connected System. Able to connect to the database in question via phpMyAdmin over browser.

Thoughts? Thanks.

mathieud0001
mathieud0001Answer
Genius
Jun 13, 2023 11:31 PM UTC

How is your community edition still running MySQL? Should be MariaDB.

URL should look something like this: jdbc:mariadb://database:3306/InventoryApp?useOldAliasMetadataBehavior=true

View in thread

7 replies

mathieud0001
mathieud0001Answer
Genius
Jun 13, 2023 11:31 PM UTC

How is your community edition still running MySQL? Should be MariaDB.

URL should look something like this: jdbc:mariadb://database:3306/InventoryApp?useOldAliasMetadataBehavior=true

    harshitb6843
    harshitb6843
    Brainy
    Jun 14, 2023 5:51 AM UTC

    If this is some other My SQL instance that you are trying to connect, then probably your creds or connection string is incorrect. 

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    Jun 14, 2023 6:22 AM UTC

    In the Appian CE, there is one data source already pre-configured. There is no need to set up another data source as long as the credentials are the same.

    pato0001Author
    New Participant
    Jun 17, 2023 2:20 PM UTC

    I'm trying to connect to an external data source.

    mathieud0001
    mathieud0001
    Genius
    Jun 17, 2023 2:27 PM UTC

    Are you able to connect to that DB using a database client? (i.e. MySQLworkbench)

    Terms & ConditionsAccessibility statement