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.
Discussion posts and replies are publicly visible
How is your community edition still running MySQL? Should be MariaDB.
URL should look something like this: jdbc:mariadb://database:3306/InventoryApp?useOldAliasMetadataBehavior=true
If this is some other My SQL instance that you are trying to connect, then probably your creds or connection string is incorrect.
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.
I'm trying to connect to an external data source.
Are you able to connect to that DB using a database client? (i.e. MySQLworkbench)
I would recommend re-checking the creds and the connection URL.
Thanks for quick reply. No luck with Workbench either. Must be cred issue.