cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
gbag3 Frequent Visitor
Frequent Visitor

Netezza (IBM)

Hi,

   Different server runs in different platform.  I am wondering if anyone knows what the code is to connect Netezza through Advance Editor.

 

Here is what I have so far for SQL Server and Oracle db:

- Oracle.Database("dbname", "datasource", {SQLQuery])

- SQL.Database("db", "datasource", {SQLQuery])

 

What is the code for Netezza connection?

 

Thank you,

Garry

 

 

8 REPLIES 8
Microsoft v-yulgu-msft
Microsoft

Re: Netezza (IBM)

Hi @gbag3,

 

Since Power BI desktop June Update, it supports IBM Netezza Connector (beta) connector. You can connect to Netezza via this option directly, then, change to Query Editor mode to get the detailed connection code.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gbag3 Frequent Visitor
Frequent Visitor

Re: Netezza (IBM)

Thank you, @v-yulgu-msft.

I am looking for the code because I am trying to take advantage of the Manage Parameter to auto run the query.  I will try neteeza.database(.... and see if it works.  Also, the getdata->Neteeza (from June update) has not work for me.  I have to ask our db admin and make sure nothing is wrong on our side first.

 

If someone from the forum can tell me the exact function, i will appreciate it.

 

Thank you,

Garry 

Microsoft v-yulgu-msft
Microsoft

Re: Netezza (IBM)

Hi @gbag3,

 

Personally, to use parameter in Power Query, you could firstly connect to Neteeza (getdata->IBM Neteeza), then, locate to Advanced Editor, replace the static part with parameter value. There is no need to type into connection code manually. Also, after connecting to Neteeza, the connection code will be generated automatically, you can view it.

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gbag3 Frequent Visitor
Frequent Visitor

Re: Netezza (IBM)

Hi @v-yulgu-msft,

    Thank you for the respond back.  

"Also, after connecting to Neteeza, the connection code will be generated automatically, you can view it"

 

Can you share the connection code from Advance Editor? Currently, I am not able to connect through GetData-Neteeza.

 

I apologize for the late reponse.

 

Thank you,

Garry

Microsoft v-yulgu-msft
Microsoft

Re: Netezza (IBM)

Hi @gbag3,

 

Unfortunately, I am unable to test as I don't have a IBM Netezza database in my environment. You said you cannot connect through GetData-Neteeza, is there any error message when you connect?

 

Regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gbag3 Frequent Visitor
Frequent Visitor

Re: Netezza (IBM)

Hi @v-yulgu-msft,

     The error message I am receiving is below.

 

"Unable to connect

We encountared an error while trying to connect.

Details: "ODBC:ERROR [08S01][Microsoft][Netezza](1001)

Communication link with server failed."

 

Version: 2.47.4766.801 64-bit (June, 2017)

 

I checked with someone and I have the correct server and database names.

 

Thank you for your help.

Garry 

Microsoft v-yulgu-msft
Microsoft

Re: Netezza (IBM)

Hi @gbag3,

 

Have you installed Netezza ODBC driver on your machine? If you have intalled, then, please try to connect to the same Netezza DB through other client tool, if it still fails, I would suggest you post your question on Netezza forum for more advice.

 

Best regards,
Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
gbag3 Frequent Visitor
Frequent Visitor

Re: Netezza (IBM)

@hank you @v-yulgu-msft.   I will look into that.

 

 

Garry

   

Helpful resources

Announcements
Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors