Hey Venkat, you should be able to set your Data Source to use a JDBC connection and a specific SQL statement. That SQL statement can contain one or more joins, subqueries, or any other standard SQL.
Let me know if you still having an issue here. I've never heard of this, but it's probably just that some options got disabled. You might need to ask a platform admin what's up with that.
Normally, that would require setting up what is called a Mid Server which serves as a passthrough to the network where the ORACLE database lives. Are you talking about in a real corporate environment, or are you wanting to do this all locally with a Personal Developer Instance and local database?
What "File retrieval method" is best for a file on your local hard drive?
Thank you..how do we pull data from more than one tables basically a join query from Oracle source
Hey Venkat, you should be able to set your Data Source to use a JDBC connection and a specific SQL statement. That SQL statement can contain one or more joins, subqueries, or any other standard SQL.
The combo list of type of connections is different for me. I don´t see JDBC alone. Can u help pls?
Let me know if you still having an issue here. I've never heard of this, but it's probably just that some options got disabled. You might need to ask a platform admin what's up with that.
I dont have a table option in the filter section
I want to connect my ServiceNow app to oracle database. And then see data somewhere in ServiceNow. How to do this? Please help
Normally, that would require setting up what is called a Mid Server which serves as a passthrough to the network where the ORACLE database lives. Are you talking about in a real corporate environment, or are you wanting to do this all locally with a Personal Developer Instance and local database?
@@knewget both lke first I want to do in my pc then I want to achieve this in corporate.