Data360 Analyze

 View Only
  • 1.  Elastic Search

    Posted 10-16-2020 01:44

    Hello,

    any way to connect an ElasticSearch base? Or the only solution is to read JSON files?



  • 2.  RE: Elastic Search

    Employee
    Posted 10-16-2020 02:39

    An online search on the ElasticSearch capabilities provided the following options:

     

    ElasticSearch provides a REST API which could be leveraged using the HTTP node.

    https://www.elastic.co/guide/en/elasticsearch/reference/current/rest-apis.html

     

    There is also a JDBC Driver for SQL access:

    https://www.elastic.co/guide/en/elasticsearch/reference/current/sql-jdbc.html

    https://www.elastic.co/guide/en/elasticsearch/reference/current/xpack-sql.html

     

    ElasticSearch can also be accessed via the low-level API Python wrapper module:

    https://www.elastic.co/guide/en/elasticsearch/client/python-api/current/index.html

     

     



  • 3.  RE: Elastic Search

    Posted 10-16-2020 02:49

    Thanks Adrian for your swift answer



  • 4.  RE: Elastic Search

    Posted 10-26-2020 01:56

    Adrian, the elasticsearch module is not installed by default, should I ask our server administrator to install it? If yes in which directory ?



  • 5.  RE: Elastic Search

    Employee
    Posted 10-26-2020 03:56

    If you want to use the elasticsearch Python module then yes, like any other 3rd party Python package, it needs to be installed. We recommend you do install the package in a sub-directory of your Analyze installation's 'site' directory. This is because this location is maintained during the upgrade of the Analyze application software. The directory you install the package into can be named anything you like for instance <site>/python/site-packages  - however you will need to ensure that this directory is added to the search paths being used by the node to find installed packages. You can include this directory by adding a a couple of statements to the start of your Python script.

    import sys, os
    sys.path.append(os.path.abspath("/path/to/directoryContainingInstalledPackages"))

    Note that when using the Transform node and Generate Data node (which are Jython-based), the recommended directory is <site>/lib/jython2. From Analyze release v.3.6.4 this directory is already included on the library search path so the Jython-based nodes will automatically find packages installed in this directory.

     



  • 6.  RE: Elastic Search

    Posted 10-26-2020 04:03

    Thanks Andrian,

    is elasticsearch module compatible with Infogix's Python 2.7?



  • 7.  RE: Elastic Search

    Employee
    Posted 10-26-2020 04:13

    Infogix do not test 3rd party packages for compatibility. However, the package distribution information indicates it is a Pure Python package and written for use with Python 2 and Python 3 distributions:



  • 8.  RE: Elastic Search

    Posted 10-26-2020 04:17

    Thank you



  • 9.  RE: Elastic Search

    Posted 10-26-2020 06:49

    Adrian, which site do you recommend to download the correct version of the elastic python module to be sure that everything will be ok with our server (RED HAT 9.0.31 (Linux))?



  • 10.  RE: Elastic Search

    Employee
    Posted 10-27-2020 04:01

    The repository should be automatically resolved by the pip module when you use the command:

    python -m pip install elasticsearch

     

    However, the Analyze application is currently supported on RHEL 7.x and 8.x   - did you mean 7.9 in your question above?