I’ve been trying to connect my robot to an Oracle database.
I read one of the articles under “Knowledge Base” called “How to query data from a SQL database” which states the workflow to query a DB, I cant really see anything that helps to connect to the DB, rather than this:
“A. First connect to the database using the Connect activity. This activity requests a connection string used to establish a database connection and a ProviderName. The string must contain a data source, a user name and a password”
However is vague and it does not justify what the String format should look like.
I need some insights from someone who managed to successfully connect to a DB with a String example and a connection setting summary