Details

    • Sub-task
    • Status: Closed
    • Major
    • Resolution: Information Provided
    • 6.0
    • None
    • documentation, SolrJ
    • None

    Description

      Integrating SolrJ JDBC with an ODBC-JDBC bridge will use useful for software like Excel/Tableau/etc. This should be documented on how to set it up.

      1. Setup ODBC-JDBC bridge according to vendor instructions
      2. https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-Generic

      Attachments

        Issue Links

          Activity

            krisden Kevin Risden added a comment -

            See chain of comments about ODBC on Mac in SOLR-8659

            krisden Kevin Risden added a comment - See chain of comments about ODBC on Mac in SOLR-8659
            krisden Kevin Risden added a comment -

            Using the OpenLink ODBC-JDBC driver with Mac and Windows seems to work. I have some details here: https://github.com/risdenk/solrj-jdbc-testing/blob/master/odbc/README.md

            Not sure if makes sense to plug an specific ODBC-JDBC bridge companies in the official Solr documentation. Here are the generic steps:

            1. Setup ODBC-JDBC bridge according to vendor instructions
            2. https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-Generic

            krisden Kevin Risden added a comment - Using the OpenLink ODBC-JDBC driver with Mac and Windows seems to work. I have some details here: https://github.com/risdenk/solrj-jdbc-testing/blob/master/odbc/README.md Not sure if makes sense to plug an specific ODBC-JDBC bridge companies in the official Solr documentation. Here are the generic steps: 1. Setup ODBC-JDBC bridge according to vendor instructions 2. https://cwiki.apache.org/confluence/display/solr/Parallel+SQL+Interface#ParallelSQLInterface-Generic

            I am struggling to make the ODBC-JDBC driver work on windows at my workplace.

            Any pointers on how to do that on windows ? (Above read-me seems to be for mac usage)

            shishircc@gmail.com Shishir Choudhary added a comment - I am struggling to make the ODBC-JDBC driver work on windows at my workplace. Any pointers on how to do that on windows ? (Above read-me seems to be for mac usage)
            erickerickson Erick Erickson added a comment -

            Please ask questions like this on the user's list, you'll get many more people seeing it and probably a much faster reply.

            When you do post there, state what you've tried and what your results are, what errors you receive etc.

            erickerickson Erick Erickson added a comment - Please ask questions like this on the user's list, you'll get many more people seeing it and probably a much faster reply. When you do post there, state what you've tried and what your results are, what errors you receive etc.

            People

              krisden Kevin Risden
              krisden Kevin Risden
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: