Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Vertica Integration with oracle fusion cloud.

Hello,

We have a requirement to integrate vertica enterprise mode 9.1 with Oracle Fusion Cloud.
From oracle side we got to know their is no feature/adapter to do so right now and they might consider
it as a enhancement for future releases.

If their any other way/approach to achieve this integration?

Answers

  • moshegmosheg Employee
    edited July 27

    One of the new exciting features available from Vertica 10.1 is the ability to query another database from Vertica and achieve an order of magnitude faster results than other DB, using Vertica's Partition pruning and predicate pushdown.
    This new scale of performance can be obtained via two components:
    The new ODBC LOADER UDL written by Maurizio Felici and the new changes made by Vertica RnD in Vertica v10.1
    It can be obtained from the Vertica Extension Packages GitHub Loader Page here:
    https://github.com/vertica/Vertica-Extension-Packages/tree/master/odbc_loader_package

  • Thanks @mosheg Oracle Fusion Cloud Applications is the connected SaaS suite,,,any documented way for the integration in vertica 9.1 or higher.

  • siddyashsiddyash Employee

    Hello,
    Question? Is there a particular Fusion application/product that you are looking to connect with Vertica? Because we have integration with few of the product like ODI and OGG and we have published the integration document on our website.
    1. ODI- https://www.vertica.com/kb/ODIcg/Content/Partner/ODIcg.htm
    Please let me know which product that you are looking for.
    Thanks.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.