how to connect SQL server Data Source with Appian

Question

It is very difficult to figure out what should be the inputs of the mentioned fields on this page.
Can someone please explain what input should be given in each of these fields and especially on the "Connection String"?

P.S: Don't give links to documentations.

Your help will be highly appreciated.

Thanks

Harshit Bumb (Appyzie) · Answer

If you select the "Type" then a sample connection string will appear. You can copy that, make necessary changes to it, and paste it there.
I will advise to go for creating a connected system instead of configuring a Data source in Admin Console

Mathieu Drouin · Answer

You never answered my question 
 But regardless, based on the limited information you provided, I'm assuming that you're probably trying to access a local database on your laptop from either a cloud or on-prem instance. In both cases, you need to make sure that your database is visible to the Appian instance. 
 Not sure what else to say beyond that if you're not willing to share more information.

Mathieu Drouin · Answer

That won't work unless you can expose your local laptop database to the internet.

venkat Avuluri · Answer

Connection string is generated while You created a schema in Table (Did you saved it anywhere?) . 
 Connection Url = Connection string

Harshit Bumb (Appyzie) · Answer

So your DB administrator should have given you a port number and an IP address that you use to access the DB in your tool (DBeaver, SQL workbench) which is your followed by the port number. Finally, you add your DB name in place of < your_db_name> and that is how you build a connection string.

Mathieu Drouin · Answer

https://docs.appian.com/suite/help/23.4/Configuring_Relational_Databases.html#sql-server 
 jdbc:sqlserver://such_as_sqlServer.example.com:1433;databaseName=such_as_MS-SQL_for_appian

how to connect SQL server Data Source with Appian

Top Replies