cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resolver I
Resolver I

AS400/iSeries DB2 database connectivity question

I am working for a company where I have access to the AS/400 but not as an Administrator so my rights are very limited.

If an ODBC connection needs to be configured; I also may need assisstance.

I need to know how to explain to our current 3rd party how to do any configuration that would allow me to pull data from our as400(I know name and IP address) DB2 database(dont know name) into Power BI desktop via Get Data - IBM Db database.

Thanks in advance to all the Power BI Desktop experts.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: AS400/iSeries DB2 database connectivity question

HI @Jferrell ,

For setting AS400 odbc driver, you can refer to the following document:

How To Set Up ODBC Connectivity To An AS/400 

In addition, you can also try to use web connector with IBM I APIs to get data from AS400:

Modernize your platform with IBM i 7.4_APIs by category 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
Highlighted
Community Support
Community Support

Re: AS400/iSeries DB2 database connectivity question

HI @Jferrell ,

For setting AS400 odbc driver, you can refer to the following document:

How To Set Up ODBC Connectivity To An AS/400 

In addition, you can also try to use web connector with IBM I APIs to get data from AS400:

Modernize your platform with IBM i 7.4_APIs by category 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors