Verified Answers

If an answer to your question is correct, click on "Verify Answer" under the "More" button. The answer will now appear with a checkmark. Please be sure to always mark answers that resolve your issue as verified. Your fellow Community members will appreciate it!  Learn more

  • State Verified Answer
  • Replies replies
    2
  • Subscribers subscribers
    9
  • Views views
    112
  • Users 0 members are here
Related
Options

How to query data from a Oracle DB and insert the output to postgres DB using OO Flow

Anand Raju

Hello, 

 In our environment, we have OO 2020.08 running on RHEL. We have a requirement to connect to an Oracle database and query data and insert the output data into a postgres dat and we would like utilise OO flow to achieve the same. In the available library, we can find only operations to run the sql select but not much options of the insert operation. Could you please anyone let me know how we can achieve this.

Thank you in advance.

  • Verified Answer

    +1  

    There is no out of the box operation that can do what you are looking for. Please test two operations from the Base CP located in,

    /Base CP/Library/Operations/Databases/JDBC/SQL Command

    /Base CP/Library/Operations/Databases/JDBC/SQL Script

    Before using any of the above operations, read the descriptions of both operations and decide which one is more suitable, and test the command/script first directly in the DB to make sure it is working.

    If the operations do not meet your need, you may create OO operations that run Windows CMD and then run the sqlcmd utility. Please refer to the document below for creating operations,

    https://docs.microfocus.com/doc/Operations_Orchestration/2020.08/CreateOperation

  • 0 in reply to   

    Hello Sam,

    Thank you for the reply and the suggestions. As of now I have managed to achieve it by using the SQLQueryLOB and SQLCommand to query and insert the data. However, its consuming more time as the read/insert works for each row and multiple query calls are made. I will try to optimize it by exploring the options of the operations.

    Once again thank you for your response.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.