Hi ,
I tried to connect oracle db as external data integration through service center.
I have given all the connection properties i,e which are asked as below in service center
NLS_LANGUAGE Parameter Value
NLS_LENGTH_SEMANTICS Parameter Value
Configuration Parameters
Username & Password
It is displaying an error message as shown in below :
Connection String test failed: '(DESCRIPTION' is an invalid connection string attribute
Can anyone brief a solution for it ?
Hi vijay r,
Please check the documentation and get an idea.
https://success.outsystems.com/documentation/11/extensibility_and_integration/integrate_with_an_external_database/integrate_with_an_external_database_using_integration_studio/?_gl=1*1uzpplx*_ga*MTc1NTIyNDYwNC4xNjc1MDY4NTQ5*_ga_ZD4DTMHWR2*MTY4MzYzOTI1MC4zMDguMS4xNjgzNjM5Njg1LjU0LjAuMA..
Thanks,
Ramesh
Hi Ramesh,
Thanks for your suggestion,
Actually I tried this looking on the url you shared already.
I have tried both basic and advanced configurations but it is displaying
for basic :
Connection String test failed: ORA-12154: TNS:could not resolve the connect identifier specified
for advanced :
I want to know if my configurations is wrong ? I am trying to do this in personal environment.
If you are doing this from your PE, are you sure that the Oracle database you are trying to reach is accessible from the internet?
The Oracle DB is accessible with Network Alias but not able to connect with connect identifier, so I am looking on it..
After adding Data Source = <db name> in the connection string , now I face this issue
Let me know if any solutions for it.
Check your database connectivity. create udl file and check.
https://stackoverflow.com/questions/17680399/cmd-test-database-connection
see able to connect your database or not.
https://www.sqlservercentral.com/blogs/udl-files-and-connection-strings
https://social.technet.microsoft.com/wiki/contents/articles/1409.how-to-create-a-sql-connection-string-for-an-application-udl-file.aspx?Redirected=true
connection is good. check the connection string.
Thanks for the suggestions,
Please guide me if this is only for SQL server or for Oracle too.
Because I do not have server name in Oracle. I tried using service name & database name as server name in the properties.
I get this below error after entering username and password & tried to select the database on the server.
Vijay R