ESP dSeries Workload Automation

 View Only
  • 1.  CA WA Load CSV To Oracle DB

    Posted Jun 24, 2022 09:34 AM
    Edited by David Lock Jun 24, 2022 10:55 AM
    Hi Guys,

    RE: CA WA Load/Import CSV To Oracle DB

    We have a need to load some data into an Oracle DB on a regular basis from CSV files.
    I do not see any built in jobs or ability to load from a CSV file into a given database.

    IN DE Series we have SQL job, Stored Procedure, Trigger.

    It looks like we will have to write a custom script for each file?

    Anyone else had a need for this?    Did you just write a script to load data?

    Thanks in advance.

    David


  • 2.  RE: CA WA Load CSV To Oracle DB

    Broadcom Employee
    Posted Jun 27, 2022 09:14 AM
    Hi David,
    You can look into sqlldr (SQL Loader) command.  That can be used as Unix or Windows command to load your data, see here as well.


    HTH,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 3.  RE: CA WA Load CSV To Oracle DB

    Posted Jun 27, 2022 09:39 AM
    Hi Nitin,

    Yes we do have a SQLLoader script today we use with a UNIX job, although we do use it directly on the Oracle database which is not ideal from a security perspective.   This is all very custom and and is not Plug-N-Play from DE Series.

    I am not sure if DE Series even comes with an Oracle Client installation, where we could use sqlldr command from.
    I believe its not a native Linux or Windows command, and we need to install an Oracle Client to perform these operations.

    My wish is for built in feature for this.
    https://community.broadcom.com//viewidea/?IdeationKey=2e0e2ff6-4698-4c7f-9896-80ea226d4b73

    I very much appreciate the help and reference.

    Thanks

    David







  • 4.  RE: CA WA Load CSV To Oracle DB

    Broadcom Employee
    Posted Jun 27, 2022 09:57 AM
    Hi David,
    Yes, DE doesn't install and use Oracle client.  It simply use JDBC to connect to any database.
    Thanks for opening the enhancement request.  Our product management will look further in to it.


    Sincerely,
    Nitin Pande

    ------------------------------
    Support
    Broadcom
    Toronto
    ------------------------------



  • 5.  RE: CA WA Load CSV To Oracle DB

    Posted Jun 27, 2022 10:43 AM
    Hi Nitin,

    Thank you Sir! 

    Yes shame DE doesn't have an Oracle Client available to use, but I guess that would then require MySQL and other DB Clients too.
    OK, let's see what the community say and if there's enough buy in from the community and product management for this feature.

    For the time being I will look at installing an Oracle client onto an DE Agent VM and run as you indicate sqlldr commands through tghe client.
    https://docs.oracle.com/database/121/LACLI/inst_task.htm#LACLI1383

    Thanks

    David