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
Discussion posts and replies are publicly visible
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
docs.appian.com/.../data-source-connected-systems.html
i have already gone through that and selected SQL server in the type category but nowhere does it mentions the format and sequence of the other inputs. Also it doesn't give clear instructions for creating a connected system.please explain this further:Example: jdbc:sqlserver://yourserver.example.com:1433;databaseName=your_db_name
Connection string is generated while You created a schema in Table (Did you saved it anywhere?) .
Connection Url = Connection string
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 <yourserver.example.com> 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.
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
Nowadays we prefer to configure a data source using a connected system instead of the admin console.
in connection URL the hidden part is my <hostname:portnumber>and username is what SQL server uses with Windows authentication and password is same as what i use for system. what am i doing wrong here.thanks for participating in my discussion.
Are you sure you have access to this database from the Appian instance? Are you trying to access an on-prem database from the cloud by any chance?
i'm accessing from local database which is on my laptop