Write File using FTP Adapter in OIC

แชร์
ฝัง
  • เผยแพร่เมื่อ 13 ธ.ค. 2024

ความคิดเห็น • 33

  • @jithintv
    @jithintv ปีที่แล้ว

    Life saving video !

  • @karthikMahadev01
    @karthikMahadev01 3 ปีที่แล้ว

    How to use XSLT date functions in Mapping

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว

      as the normal function, you can drag and drop the date time function on the required target fields.

  • @omarc429
    @omarc429 3 ปีที่แล้ว

    Hi. When transferring files from cloud to an external sftp Linux server via the agent, what will the ownership and permissions of the files be set to once they have landed on the target sftp Linux server?

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว

      If this is read only then I guess, read only permission is required.

    • @omarc429
      @omarc429 3 ปีที่แล้ว

      @@TechSupper will files be automatically created as oracle user.

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว +1

      I didn't check this, try this yourself and see the permission.

    • @omarc429
      @omarc429 3 ปีที่แล้ว

      @@TechSupperThanks. Your uploads are very informative. If 3rd party triggers an integration through API which has 2 steps, 1. Create extract file & 2. Transfer file to 3rd party sftp server. Can we call a API to monitor the status of each of these steps and determine success or failure? Do you have any uploads for this content? Thanks

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว

      No, there is no such API to montior things step by step.

  • @kostaresepe9418
    @kostaresepe9418 3 ปีที่แล้ว

    Hello ankur can we write .pdf file or any other adapter for .pdf file generation?

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว

      You can't generate the PDF directory from OIC, but here is the approach:
      1) Create a function in Oracle OCI that takes inputs (name, email address..) and generates pdf as expected and return the PDF output
      2) Call the function REST API in OIC
      3) Extract the pdf from function REST API and attach it to HTML
      Here is the sample reference blogs.oracle.com/integration/post/how-to-invoke-an-oci-function-from-the-oracle-integration-cloud.

  • @usiuelali
    @usiuelali 3 ปีที่แล้ว

    Hi Ankur, I tried the steps mentioned in this video but I a getting error at the zip file stage activity saying "/temp" folder not found where we are downloading it to ICS temporary location.

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว

      Which folder path you have given while writing the file on stage and what path you are using to zip the folder on stage.

  • @abhishek-bb6vg
    @abhishek-bb6vg 4 ปีที่แล้ว

    Hello,
    Question1 :Please explain what is top level array .
    Question2: Please correct me if i'm wrong with below understanding.
    you map the values to repeat element(2 of 2) at time 7:57 instead of 1 of 2 since (1 of 1) is a header part in the CSV file and 2 of 2 is actual data. Top level array concept comes because the json file is in Array format.
    Question3: What are record set name and record name shown in FTP file content definition(as I can see the record set name and record name in the target window mapping at 7:57). I guess sample.csv that you uploaded only for structure purpose. please confirm.
    Question4: At 8:50 you hard coded the status value on the target but I could not see you map the source to target.Please confirm have you map it or not .If map it ignore kindly question 4

    • @TechSupper
      @TechSupper  4 ปีที่แล้ว +1

      Ans1) When you provide an unnamed array as sample json, it shows top-level array node by default which indicates it's node is an array type.
      Ans2) It's correct
      Ans3) That's correct. RecordSet Name becomes the parent node and Record name becomes the child node in target mapper.
      Ans4) Just hardcoded value as a response. We have mapped the actual data at 7:57

    • @abhishek-bb6vg
      @abhishek-bb6vg 4 ปีที่แล้ว

      @@TechSupper Thank you so much Ankur Jain, for the clarifications.

    • @TechSupper
      @TechSupper  4 ปีที่แล้ว

      You're Welcome.

  • @MrVenkatesh182
    @MrVenkatesh182 4 ปีที่แล้ว

    Can you please let me how the mapping should be done when I have more than 10 records in the source file. Should we repeat the node as you have shown in the video?

    • @TechSupper
      @TechSupper  4 ปีที่แล้ว

      Hi,
      Map the array element from source to target which will do for-loop automatically.
      Regards,
      Ankur

    • @monicasosa3117
      @monicasosa3117 3 ปีที่แล้ว

      @@TechSupper Example please

  • @MohsinKhanSC
    @MohsinKhanSC 5 ปีที่แล้ว

    What are the details you are giving in REST Conn? are you using any public API?

    • @TechSupper
      @TechSupper  5 ปีที่แล้ว

      Hi Khan,
      I'm using public REST API to create connection
      jsonplaceholder.typicode.com/

  • @RathoreFitnessAndNutrition
    @RathoreFitnessAndNutrition 4 ปีที่แล้ว

    Nice explanation 👍

  • @karthikMahadev01
    @karthikMahadev01 3 ปีที่แล้ว

    SAMPLE_YYYYMMDD(Current Date)_449012.txt
    How to do this function in mapper using concat

    • @TechSupper
      @TechSupper  3 ปีที่แล้ว +1

      concat('Sample_', current-DateTime','.txt'). Please see the exact function name.

    • @karthikMahadev01
      @karthikMahadev01 3 ปีที่แล้ว

      @@TechSupper How to use XSLT date functions in Mapping

  • @moumitasarkar8993
    @moumitasarkar8993 4 ปีที่แล้ว

    Hi ankur, can you please let me know if I can read a file in OIC from my local machine? How do we do that? I have a sample file which i need to process and generate more files as an outcome.

    • @TechSupper
      @TechSupper  4 ปีที่แล้ว

      Hi Moumita,
      Yes you can do for sure. Install the connectivity agent on your local machine. Create a File adapter and use the file adapter to read/write on your local machine.
      Regards,
      Ankur

    • @TechSupper
      @TechSupper  4 ปีที่แล้ว

      Thanks. You can buy the Udemy course which will help you You can buyd Udmey course to learn Integration and VBCS in more detail
      www.udemy.com/course/oracle-integration-cloud-oic-in-depth/?referralCode=EE35C319CF22E23E7FD4
      Apply coupon code "TECHSUPPER" and get flat 30 % discount
      Reards,
      Ankur