List of Contributions

Holger Schimanski

Contact Details

My Content

1 to 20 of 22 total

RE: Union of list of tables

Posted By Holger Schimanski 09-07-2018 01:55
Found In Egroup: Data360 Analyze \ view thread
Thank you very much for providing a demo workflow! :-) I notice, that you are using the Output BRD File node and not the CAT node. But my input tables have slightly different column structures. CAT has ConcatenationMode = Union ("Outputs all of the fields across the inputs, filling in ...

Union of list of tables

Posted By Holger Schimanski 08-29-2018 05:57
Found In Egroup: Data360 Analyze \ view thread
I have a config file with a list of tables. These tables should be merged and written into one table. The Cat node does the job of merging resp. the different tables. But I have up to 100 tables for the Cat union and the list of tables needs to be a config file or parameter rather that individual ...

RE: Central configuration of JDBC connection

Posted By Holger Schimanski 08-06-2018 03:58
Found In Egroup: Data360 Analyze \ view thread
Hello Adrian! Has there anything implemented or changed in Dataverse regarding centralized configuration of JDBC connections since your last post? Best regards Holger

RE: CSV Import with autoname columns

Posted By Holger Schimanski 09-05-2017 23:32
Found In Egroup: Data360 Analyze \ view thread
Similar problem by the way with JSON node. We have JSON response from webservice which uses ":" in some JSON object names, and JSON node throws an error not being able to handle these names. The JSON node should autorename these columns and replace or escape the ":" automatically.

Number of records not properly shown in data preview

Posted By Holger Schimanski 09-05-2017 05:24
Found In Egroup: Data360 Analyze \ view thread
In the data preview area the Dataverse 3.1.4 there is content about number of rows not correctly shown (using IE 11). See screenshot below with "33 records" at the left bottom.

RE: Annotations?

Posted By Holger Schimanski 09-04-2017 22:53
Found In Egroup: Data360 Analyze \ view thread
Dear Robert! Inline documentation is very important for creating cutom nodes. I want to be able add description text to parameters (when hovering over the label of the parameter - see screenshot below currently already possible) and also include a webpage with documentation like it is done for the ...

CSV Import with autoname columns

Posted By Holger Schimanski 08-31-2017 09:41
Found In Egroup: Data360 Analyze \ view thread
I have a CSV file with duplicate column names. I have to fix this in the CSV file before being able to work with the file in Dataverse. Dataverse Gives me an error message and 0 rows in the output pin. For Excel import there is a Error Behaviour setting to autoname columns (creating column names ...

RE: JDBC Input node with table or view picker

Posted By Holger Schimanski 05-19-2017 07:34
Found In Egroup: Data360 Analyze \ view thread
I think, Central configuration of JDBC connection is more important. If you have to prioritize, than go to Central configuration of JDBC connection. :-)

RE: Central configuration of JDBC connection

Posted By Holger Schimanski 05-19-2017 07:32
Found In Egroup: Data360 Analyze \ view thread
I am using now data flow properties to centrally configure by several JDBC nodes as suggested. In general it works, but I would like to get one little improvement to make this much more convenient to use. JDBC connection is a set of 4 parameters: driver, URL, user and password. I would be great ...

RE: Automatic synchronizing LDAP/AD users and groups

Posted By Holger Schimanski 05-10-2017 08:19
Found In Egroup: Data360 Analyze \ view thread
Thank you very much for the update and nice idea how to solve it with build-in functionality. Is there also a REST API method available to trigger the update of the LDAP/AD calls? We then could easily also add REST API call to our enterprise scheduling. Best regards Holger

Automatic synchronizing LDAP/AD users and groups

Posted By Holger Schimanski 05-06-2017 01:21
Found In Egroup: Data360 Analyze \ view thread
We use LDAP/AD group as company standard to centrally managing access priviledges. We add users to AD groups and AD groups are sychonized to applications. Looking at the documentation on synchonization of Dataverse with LDAP/AD groups it sounds like, this needs to be triggered manually to get updated. ...

JDBC Input node with table or view picker

Posted By Holger Schimanski 05-05-2017 15:00
Found In Egroup: Data360 Analyze \ view thread
If I use the JDBC Input node, I would like to have a table or view picker instead of need to type in the table name by hand. That would be much more convenient and less errorprone. Tools like Tableau have a very nice UI to select a table or view or even stored procedures incl. search box and schema ...

RE: Central configuration of JDBC connection

Posted By Holger Schimanski 05-04-2017 04:53
Found In Egroup: Data360 Analyze \ view thread
That sounds perfect! Thank you very much for the hint. Maybe you can add a screenshot to the documentation, how run properties are exposed to consumers of the data workflow. Best regards Holger

Central configuration of JDBC connection

Posted By Holger Schimanski 05-03-2017 22:59
Found In Egroup: Data360 Analyze \ view thread
We are using several tables from one Oracle database for our data workflow. If I am right, then I have to provide database connection for each an every JDBC node. Is there a way to configure it once and then use this connection with multiple JDBC table input nodes? It is also a challenge when ...

Team development of data flows with branch and merge

Posted By Holger Schimanski 04-27-2017 07:22
Found In Egroup: Data360 Analyze \ view thread
Is there a way to collaboratively work on a data flow? Can I branch and merge data flows?

Duplicate a data flow

Posted By Holger Schimanski 04-27-2017 07:17
Found In Egroup: Data360 Analyze \ view thread
If I want to start a new data flow based on an existing one, it was not obvious for me, how to do that. I tried to export and import, but that failed, because I cannot change the name of a data flow when importing. I then stumbled of the hamburger button, when you have opened a data flow. From ...

RE: Use of ValidR in Dataverse

Posted By Holger Schimanski 04-21-2017 04:48
Found In Egroup: Data360 Analyze \ view thread
Thank you for discussing this with your Engineering team! Does TERR has to run on the same instance as Dataverse for this tight integration?

RE: Use of ValidR in Dataverse

Posted By Holger Schimanski 04-18-2017 04:07
Found In Egroup: Data360 Analyze \ view thread
Can you think about adding flexibility here? I very much like the predictive and statistical node pack, but don't like that much the dependency to TIBCOs Enterprise R because it creates additional license costs and I maybe don't need the performance of TIBCOs R library and favor ValidR because of ...

RE: Use of ValidR in Dataverse

Posted By Holger Schimanski 04-18-2017 02:32
Found In Egroup: Data360 Analyze \ view thread
Can I also configure the target R environment for the standard nodes from Dataverse for K-means, Decision Forest, Linear Regression etc.?

Use of ValidR in Dataverse

Posted By Holger Schimanski 04-18-2017 01:33
Found In Egroup: Data360 Analyze \ view thread
I read about the R node available in Dataverse and about statistical and predictive nodes available in Dataverse. I my organization we are using ValidR from Mango Solutions (because of special requirements and regulations in healthcare and pharma). Is it possible to run the R code from the ...