Integration

Get Involved. Join the Conversation.

Topic

    Arsalan Dilawar
    Connect Oracle cloud Database service with Microsoft sql...
    Topic posted June 17, 2019 by Arsalan DilawarGreen Ribbon: 100+ Points, tagged Adapters, API, Cloud, Connection, Database, ERP Cloud, Integration, Mapping, PaaS, REST, SOAP, Web Services 
    13 Views
    Title:
    Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tool
    Summary:
    Connect Oracle cloud Database service with Microsoft sql server without Oracle Integration Cloud tool
    Content:

    Hi,

    Good day! Need help in connectivity 

    We have created a 1 custom table in oracle PaaS. We are daily uploading the Excel sheet based data in that table using Oracle apex loader utility. 

    We are picking that data from one customize Attendance system which is developed in Microsoft sql server.

    Now my requirement is automate this process. I want my attendance system data to go directly into oracle apex table and there should be no manually activity for that..  I tried to do searching on different forums but could not find any..

    Out main problem is we don't have Oracle Integration Cloud licence and because of that we are not able to create a connectivity between oracle cloud n sql server.. Is there any other way to create a connectivity and upload the data in Oracle cloud PaaS table