This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Looker studio And AS400 - Query

Posted on 01-03-2025 03:57 AM
ALIGROSSRL
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I need to connect my AS400 as a data source in Looker Studio using a query, but I haven't found any information on this. Can someone provide some advice? Thank you.

0 5 91
Topic Labels
0 Likes
5 REPLIES 5

Posted on --/--/---- --:-- AM
GavinW
Staff
Reply posted on --/--/---- --:-- AM

I don't believe that a Looker Studio connector exists for AS400, so it will not be possible to make a direct connection between Studio and an AS400 source.

0 Likes

Posted on --/--/---- --:-- AM
ALIGROSSRL
Bronze 1
Bronze 1
In response to GavinW
Reply posted on --/--/---- --:-- AM

Ok thanks, are there any alternatives I can use? And if so, which ones?

0 Likes

Posted on --/--/---- --:-- AM
GavinW
Staff
In response to ALIGROSSRL
Reply posted on --/--/---- --:-- AM

If you wish to use Looker Studio, the only alternative I can think of would be to either a) move the data to some system that a connector does exist for or b) extract the data into a CSV file and upload it to Looker Studio.

0 Likes

Posted on --/--/---- --:-- AM
ALIGROSSRL
Bronze 1
Bronze 1
In response to GavinW
Reply posted on --/--/---- --:-- AM

Can you suggest a method to export from a query to CSV without going through Excel?

0 Likes

Posted on --/--/---- --:-- AM
GavinW
Staff
In response to ALIGROSSRL
Reply posted on --/--/---- --:-- AM

Unfortunately I cannot, I know nothing about AS400 or your environment - I wonder is there somebody in your organisation who would be more helpful?

0 Likes