1

So my team is looking into connecting to Netezza with C# and we plan on loading data into netezza, pulling data from netezza and writing update queries all in C#.

From my research, I see that it's possible to connect to netezza using C# and I'm wondering if you can do all that is bolded above using C# so that we can decide on whether or not we can do just about anything with Netezza using C#. We'd like to know before we commit to anything. The types of data we would be loading are CSV files.

Are there any good resources on this? I haven't been able to find any.

We also have Aginity client tools so maybe it's possible to incorporate Aginity to this (Not that I would want to but if it's easier I'd like to know about it)?

jim
  • 1,026
  • 2
  • 15
  • 37
  • loading and exporting CSV into netezza should be straightforward and you need not use any other interface and you can do directly within netezza. i am not sure about netezza, I feel you should try contacting SAS customer support too on this for loading SAS tables using C#. I do not have any knowledge on C# connectivity, so cannot commenton that – Kiran Nov 06 '18 at 12:46
  • @Kiran So are you saying that you can use C# to load and export CSV into Netezza? – jim Nov 06 '18 at 12:53
  • i think you can do it in aginity work bench and they are sevral scripts online for that. – Kiran Nov 06 '18 at 12:55
  • @Kiran so let's say I'm writing a program using C#, you're saying I can connect to Aginity in order to execute these tasks? Does Aginity have a command line interface that can be called or something? – jim Nov 06 '18 at 12:58
  • I tcannot automate and probably that is where you have to use C# and that is where you need C# – Kiran Nov 06 '18 at 13:10
  • @Kiran so based on your first comment, you're saying it would be easy to connect to Netezza and upload CSV files all with C#? – tee Nov 06 '18 at 14:11
  • or any other software, it should be pretty straighforward – Kiran Nov 06 '18 at 16:08

1 Answers1

1

Retrieving data is straightforward and can be done through the usual channels (loop over a cursor to get results) but loading can take a bit longer.

Netezza is not a fan of multiple INSERT queries; loading a large number of records with individual INSERT queries, as it doesn't support multi-row inserts, will take a long time.

When loading multiple records most people usually write out their data to a ".csv" and use the external table syntax to perform the insert.

When in a application we prefer to load/unload our data via a named pipe so that we don't have to write/read the data to disk prior.

joebeeson
  • 4,159
  • 1
  • 22
  • 29