List of Contributions

Murali Menon

Contact Details

My Content

1 to 18 of 18 total

RE: Reimplement Pivot nodes in new syntax

Posted By Murali Menon 02-17-2021 02:37
Found In Egroup: Data360 Analyze \ view thread
Thanks for the update. I look forward to the new nodes.

Reimplement Pivot nodes in new syntax

Posted By Murali Menon 02-15-2021 02:14
Found In Egroup: Data360 Analyze \ view thread
is there a plan to reimplement the data-names pivot and names-data pivot nodes in the new D360 Analyze? as of 3.6.2, i notice the underlying functionality is still in brainscript / java nodes, and is not particularly fast. for example, i did a 3-way hash-split on 220 million records and performed ...

Enabling HTTPS

Posted By Murali Menon 01-22-2021 07:48
Found In Egroup: Data360 Analyze \ view thread
The steps provided in the D360 Analyze online documentation to enable HTTPS on the D360 server are incomplete. The keytool -genkey command results in the creation of a common name (CN) referencing the DNS name of the server in the eventual self-signed certificate. However, this means that ...

RE: REST API with https enabled on Analyze server in Google Cloud

Posted By Murali Menon 09-24-2020 06:38
Found In Egroup: Data360 Analyze \ view thread
As part of the conversion from http to https, my colleague had imported a self-signed cert into Analyze's embedded Java cacerts per these instructions: https://d3sa-preview.infogixsaas.com/docs/dist/help/Default.htm#j-admin/enabling-https.htm We were able to connect from our browsers to the Analyze ...

REST API with https enabled on Analyze server in Google Cloud

Posted By Murali Menon 09-24-2020 05:52
Found In Egroup: Data360 Analyze \ view thread
Hello Following support query 161057, we successfully activated https access to our D360 Analyze server in the Google Compute platform. We can access Analyze on the server from our local browsers using https, and do our design work as normal. However, now we are having trouble using the ...

RE: Importing pure python packages into Analyze's transform nodes

Posted By Murali Menon 03-03-2020 08:30
Found In Egroup: Data360 Analyze \ view thread
Before I saw the above, what I did was: 1. use the pip from my Python installation to download and install my desired pure Python package. 2. it had no dependencies, so no worries there 3. copied the package folder from the Python installation to the D360 Jython's site-packages folder ...

Importing pure python packages into Analyze's transform nodes

Posted By Murali Menon 03-02-2020 04:49
Found In Egroup: Data360 Analyze \ view thread
I understand that many Python modules cannot be used within D360 Analyze's nodes because of the former's dependencies on C/C++ libraries. But can a pure Python library be installed somewhere within D360's Jython directory structure (e.g. in platform\windows-x86-64\jython\Lib\site-packages)? Were ...

RE: Searching with unicode regular expression

Posted By Murali Menon 02-26-2020 06:52
Found In Egroup: Data360 Analyze \ view thread
Ah, very nice. Was unaware of the 'unicode_escape' option.

RE: Searching with unicode regular expression

Posted By Murali Menon 02-26-2020 06:13
Found In Egroup: Data360 Analyze \ view thread
To be honest, the inconsistent behaviour between the Create Data and the CSV nodes itself is concerning. Can a bug report be raised for this?

RE: Searching with unicode regular expression

Posted By Murali Menon 02-26-2020 05:41
Found In Egroup: Data360 Analyze \ view thread
Thanks Adrian, but I'm not certain that all the required characters are displayable - but I still need to find and replace them. The ones above are for the purposes of the query only.

Searching with unicode regular expression

Posted By Murali Menon 02-26-2020 05:22
Found In Egroup: Data360 Analyze \ view thread
I have a bunch of Unicode records containing various Unicode characters (e.g. € and †) which I want to find and replace using D360. I need to use the \u format to use the Unicode Code Points (e.g. \u20AC for the euro sign €) If I set up my search patterns in a Create Data node as follows: ...

RE: JDBC Execute node with SQL from Input Field

Posted By Murali Menon 01-10-2020 03:48
Found In Egroup: LAE \ view thread
Thanks for the responses, folks. Adrian: I was hoping that the '?' syntax would also work when specifying the database column name, but its usability appears to be restricted to the right hand side of the WHERE clause. In other words, I can't do SELECT * FROM dbtable WHERE ? = ?, and then put 'database_field', ...

RE: JDBC Execute node with SQL from Input Field

Posted By Murali Menon 01-07-2020 03:44
Found In Egroup: LAE \ view thread
Hi - does anyone have a workaround or custom node for D360 Analyze version 3.4.2 for the same purpose - via JDBC execute? We're unable to upgrade to 3.5.0 just yet, but the functionality for SQL query to be provided from node input is required.

Dataflow runtime status visibility to other dataflows

Posted By Murali Menon 08-20-2019 04:21
Found In Egroup: Data360 Analyze \ view thread
If I have a bunch of dataflows scheduled to run on a D360 Server, is it possible for another dataflow to check the runtime status of those flows? I'm thinking of having some kind of monitor dataflow that can periodically check the status, and if any the flows fail, then send an alert or some s ...

Secure JDBC connection to PostgreSQL database

Posted By Murali Menon 05-09-2019 01:15
Found In Egroup: Data360 Analyze \ view thread
I've created a PostgreSQL virtual machine instance on the Google Compute Platform. It gave me a client certificate (client-cert.pem), a client certificate key (client-key.pem) and a server certificate authority (server-ca.pem) files, which I saved on my local machine. Using the above files, I'm ...

RE: Google Cloud Storage List error: Unexpected exception in processing: java.lang.NullPointerException

Posted By Murali Menon 05-09-2019 01:09
Found In Egroup: Data360 Analyze \ view thread
Thanks, Adrian, I've raised support ticket 69566 and uploaded a zipped log file. I'm unable to reproduce the error now. As I mentioned above, when I created a new bucket, the node works without any problems.

Google Cloud Storage List error: Unexpected exception in processing: java.lang.NullPointerException

Posted By Murali Menon 05-07-2019 04:03
Found In Egroup: Data360 Analyze \ view thread
[reposting from the old forum] I've set up a service account on my project in Google Cloud computing. I've given it two roles: "Storage Admin" and "Storage Object Admin", and downloaded the private key .JSON file onto my local machine. I put in the name of the bucket I've created in Google ...

Dataverse - Hourly Paid on Google Compute Engine

Posted By Murali Menon 05-07-2019 04:00
Found In Egroup: Data360 Analyze \ view thread
I tried to activate an instance Dataverse - Hourly Paid on the Google Compute Engine platform. Following the documentation, I opened up port 8080 on the Google firewall. I was then able to obtain the login screen, but putting in the usual login/password, I received the attached error about a host ...