SSAS and AS400

• mbrady5

  SSCrazy

  Points: 2835

  More actions

  March 17, 2012 at 6:54 am

  #149093

  I am attempting to create an AS400 data source view in SSAS. The problem I am having is that there are no objects displayed to choose from to build this.

  Provider=IBMDA400.DataSource.1;Data Source=TTTTAS400

  I do not have an option for ODBC IBM client access. Not too sure what to do..?? Any ideas?

• pwallis

  Mr or Mrs. 500

  Points: 596

  More actions

  March 21, 2012 at 7:14 am

  #1462116

  You need to load the IBM Client Access OLE DB provider before you can establish a connection. It is part of the iSeries Access for Windows product.