Can one use ODP.net to connect to a Cloud instance? - Cloud Resource Model API(Archived)

Hi there
I would like to know if it's possible to use the ODP.net (Oracle Data Provider for .NET) to connect to the Database Service in the Cloud.
thanks
C 

Not currently.
A cloud instance (via Cloud API) is a resource that represents the underlying entities (i.e. Database or VM or Template). It isn't currently a direct access point to the underlying entity itself.

Related

Integrating two applications using oracle cloud integration services

Hi,I am trying two integrate two business applications.that is on premises to cloud integration.first we are creating the database table on local system and that table also can be accessible from the cloud.I am following this http://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/ics/DevelopingIntegrationFlowswithIntegrationCloudServic… but in this link they have mentioned about WSDL url.from where we will get this url for destination and source can anyone help about the steps that we have to follow. Regards,Pooja.
For integration with on-premise database (Oracle DB, MySQL, MS SQL) you will need an adapter. For Oracle DB Adapter, take a look at https://docs.oracle.com/cloud/latest/intcs_gs/ICSSB/GUID-B6DE5BB7-3188-43B7-AF38-AC41661FA527.htm#ICSSB-GUID-B6DE5BB7-31… 
Hi sir,Thanks for the reply.can you tell me we have to use adapters at source and destination or only at source?because I gone through the url which you have send but there they mentioned like we can't use MySQL Adapter  as a trigger in an integration.I am using AR(Account Receivables) at cloud side so which adapter need to be use REST adapter or ebs. Regards,Pooja.
Adapter is used to create "Connections". In your case to either a "Database" or to "ERP Cloud".After that, which "connection" goes to source and which to target depends on your use case. They can go anywhere i.e. can be used both as trigger/Invoke. Connecting to Database does not need WSDL, you need to put in Host IP and credentials, in the "Configure Connectivity"For AR you can use "REST Adapter", there is an Invoice REST API or URL available Hope it helps.
Hello sir,we are trying on premises to cloud integration.our source is on premises database and target is on cloud that is account receivables.for connecting with database we need to create WSDL url using soap web services or we have to use any adapter.is it necessary to use adapter or any approach is there.  Thanks & Regards,Pooja 
WSDL is not required when using "Database Adapter". As I mentioned you will need to input, Database hostname/IP and Port Number while configuring connectivity in the DB Adapter. Not sure what you mean by "any other approach". To put it in simple words, ICS creates Integration flows using "Connections" which are nothing but Connectors/Adapters to respective Applications.Depending upon your case, you need to select the most appropriate adapter. To summarize, in your Use case you will need to follow these steps 1. Install an Agent/Agent Group which will need a Linux machine with access to your Database Server.2. Configure Agent and create Database Connection wherein you will input Database Hostname and Port Number.3. Create a REST connection to your AR API4. Once the connections are in place and tested, you can proceed with creating actual Integration Flows. Saurabh,

Can we create new datasource connection in JCS-SX weblogic instance

Hi Experts, As far as I knew, when we get any JCS-SX instance then by default predefined weblogic and database will be associated with in the instance. I'm very much sure that we cannot create any custom schema inside of the pre-defined database in my JCS-SX. Please do correct me if I'm wrong. I have couple of questions for which I'm not able to find answers.1. Is it possible for us to create new Datasource in JCS-SX weblogic instance? If its possible then please do share the reference on this. 2. For one of the requirement, we are planning to use PaaS DBCS (JCS) one. In this we can create our own custom schemas. Can I access this PaaS DBCS details in inside of my JCS-SX application?(Eg - I'm planning to build one small ADF application which will access PaaS DBCS and when we deploy in JCS-SX, does it support to access the data. We cannot access the data untill if we don't create the datasource connection in inside my JCS-SX weblogic instance) Is it achievable? 3. What is max size that JCS-SX - predefined database? If possible please share the documentation link for the JCS-SX database compute shapes? Any inputs on this are highly appreciated. Thanks & Regards,Narendra M.
1) The SDK does contain command to add a data source, not sure if this is what you are looking for though as it just allows you to create a jndi name for the data souece, snipplet from the documentation: Command: add-datasource-jndiname    - Add a new JNDI name for a data source.  Command alias:[adddatasourcejndiname] Mandatory argument(s): ...- JNDI name of the data source associated with the Java Cloud Service - SaaS Extension. Supported Charaters in JNDI name: [a-z],[A-Z],[0-9],":",".","/","-","_".  Shortcut:jn  Optional argument(s): ...datasource                 - Name of the data source associated with the Java Cloud Service - SaaS Extension. Supported Charaters in DataSource name: [a-z],[A-Z],[0-9].   2) I am not sure I understand the question. But if you are asking whether you can access the content of the associated DB from JCS SX then yes you definitely can do that. For example with the JNDI name defined in the ADF application configuration or directly with JDBC like in this example JDBC connectivity on oracle database cloud 3) I think you should be able to see the DB size associated with JCS SX from your dashboard. For details refer to the Pricing documentation --Jani RautiainenFusion Applications Developer Relations

JCS-SX and its requirement for DB Schema Service?

I understand that JCS-SX requires the DB Cloud Service - Schema Service.  Does anyone know why JCS-SX is limited to the DB Schema Service?  Database access, database management tools, and the database size is limited when using the DB Schema Service.  For my use case, it would be more helpful to be able to connect JCS-SX to a standard DB Cloud Service. Thank You
Hi, JCS-SX and DB Cloud Service - Schema Service (APEX DB) is part of SaaS Extension and totally managed by Oracle. Hence both are bundled together. Since DBCS is a PaaS product and managed by both (Customer & Vendor), So that is why JCS-SX don't allow extension to DBCS.If you want to use DBCS for more flexibility at your end, you need to go JCS(Java Cloud Service ) and NOT JCS-SX.  Hope, It answers your query. Regards Vikash Mishra
Hi, What ever Vikash said is absolutely right. JCS-SX is a controlled environment by Oracle. If you need to use connect standard DB cloud service then it would be preferable to use JCS instead of JCS-SX. You can find more references at - Can we create new datasource connection in JCS-SX weblogic instance JCS-SX - Is it possible to add JNDI connection to DBCS with IP Address?  Thanks & Regards,Narendra M.

How to migrate integrations from One OIC instance to another including database packages

We have built around few custom integrations , we would like to migrate to another instance of Orace Integration Cloud. we are using database connector with stored DB packages.   Any idea how to migrate the integration along with database packages.  Thanks in advance. ThanksRavi
OIC migration and DB migration are mutually exclusive. You can leverage OIC REST APIs to export and import flows to other instance. If the new OIC instance is associated with different DB, it is customers' responsibility to make sure DB has right objects. So DB migration needs to be taken care before OIC migration happens.
By DB packages, do you mean wrapper packages generated by OIC while using Stored Procedures? If yes, then those are automatically recreated during activation time if they don't exist on target database. 
Hello Hemanth,thanks for the update.  Here is the scenario. Created an integration  with Rest API and its active now .on-prim DB connects to OIC through on-prim agent. For Integration using DB connector. on the on-prim DB, created DB packages  for this integrationNow we need to migrate this integration to another OIC instance which is going to use the connection from another on-prim DB As per your update, you mean while migrating this integration  to another  OIC instance, First migrate all DB objects from on-prim source DB to target DBMigrate all integration related flows next and activate this on the target instance.
Hi,thanks for the update.  Here is the scenario. Created an integration  with Rest API and its active now .on-prim DB connects to OIC through on-prim agent.For Integration using DB connector.on the on-prim DB, created DB packages  for this integrationNow we need to migrate this integration to another OIC instance which is going to use the connection from another on-prim DB As per your update, you mean while migrating this integration  to another  OIC instance, If I remember correctly , ICS_DBA objects will be created while generating or activating the integration , correct me if I am wrongFirst migrate all DB objects from on-prim source DB to target DBMigrate all integration related flows next and activate this on the target instance.ThanksRavi
Packages created by OIC Database Adapter like Wrapper packages would get created automatically again when you activate integration on another OIC instance connecting to a different database instance. Migration of any other custom DB object that was not created by OIC is user's responsibility. Thanks.

Hi, I have  a requirement to integrate Oracle Java Cloud Service with external database. I need to access the external database (oracle) and perform some operations on it.

Hi Experts, I am new to Oracle Java Cloud.I have  a requirement to integrate Oracle Java Cloud Service with external database. I need to access the external database (oracle) and perform some operations on the database . Could you please help me on this regard. Thanks,- Sridhar
Supported Application Containers and Services states:Table A-3 Java Cloud Service Unsupported Features    Unsupported FeaturesAlternativeRemote invocations with a transport protocol other than HTTPS (including plain text HTTP).Not applicable. So you would need to use for example a web service call to integrate with the external database..--Jani RautiainenFusion Applications Developer Relationshttps://blogs.oracle.com/fadevrel/
You cannot connect to external database using SQL*Net or JDBC but if your external DB support HTTP based web service interface (SOAP or REST) you can access it from JCS-SaaS Extension.  We offer  a new Java Cloud Service which may be more suitable for your use case but it's not yet available a trial, but you can purchase  a subscription to that service.

Categories

Resources