Neo4j – SSIS – Connection Manager Love

By Charlotte

I’ve not written about the SSIS components for a bit, but I have been working on them – adding things, improving things. One area that was always very basic was the Connection interface. Or lack thereof – indeed the interface was basically just the properties pane of Visual Studio – mmmm Functional. Now though, you…

Neo4j & NiFi – Getting NiFi Running

By Charlotte

Another day, another ETL tool, this time Apache NiFi which is described as: An easy to use, powerful, and reliable system to process and distribute data. I’ve used SSIS and Kettle in the past, so I figured I’d be able to get this bad boy running easy enough – I mean – it’s ‘easy to…

Reactive Neo4j using .NET

By Charlotte

Version 4.0 of Neo4j is being actively worked on, and aside from the new things in the database itself, the drivers get an update as well – and one of the big updates is the addition of a Reactive way to develop against the DB. Now – I’ve not done reactive programming for a long…

Execute Cypher Task Updates

By Charlotte

Last week, Anabranch released version 1.1 of the tools for Neo4j – which included a very welcome addition to the toolset – being able to pull data from a Neo4j instance. After doing the demo post – I noticed a peculiarity – a quirk if you will with how the ‘Execute Cypher Task’ (see here)…

Using a Data Flow to move data **from** Neo4j in SSIS

By Charlotte

That’s right everyone! We’re going from Neo4j this time, and this is a new release, the old version (1.0.0.0) didn’t have a ‘Neo4j as a Source’ component, 1.1.0.0 does. In the last post we took data from a file and ingested it into Neo4j, so far so good – but one of the things we…

Neo4j & SSIS

By Charlotte

Neo4j and SSIS are awkward bedfellows – SSIS is Microsoft and has connectors to a plethora of database and technologies using ODBC, Web etc, and Neo4j is written in Java which provides a JDBC connection. SSIS however, does not work with JDBC. #badtimes Some of the clients I’ve worked with like using SSIS – (some…

Actually using the new DataConnector for PowerBI

By Charlotte

After I’d written it – I realised my last post was perhaps not the most useful for those who really don’t care about the how but want to know what to do to use it. So this will follow the same deal as with the last post (over a year and a half ago!! WOW!).…

PowerBI With Neo4j – How do you build a DataConnector?

By Charlotte

TL;DR; Repo is at: https://github.com/cskardon/Neo4jDataConnectorForPowerBiRelease at: https://github.com/cskardon/Neo4jDataConnectorForPowerBi/releases Looky! Pie Charts! This glorious picture represents the very pinnacle of my PowerBI experience, beforehand I was pulling the data into Excel and charting myself – no longer! Jokes aside, the big news here is that I’ve dramatically improved upon my previous post where I showed how you could…