Business Intelligence Blogs

View blogs by industry experts on topics such as SSAS, SSIS, SSRS, Power BI, Performance Tuning, Azure, Big Data and much more! You can also sign up to post your own business intelligence blog.

Using Data Source to Connect with IBM-AS400

  • 30 November 2009
  • Author: AlbertoMunera
  • Number of views: 13034

Using Data Source to Connect with IBM-AS400

A data source is a connection that represents a simple connection to a data store;  it includes all tables and views in the data store.  A data source has project scope, which means that a data source created in an Integration Services project is available to all the packages in the project.

A data source can be defined and then referenced by connection managers in multiple packages. 

Creating a Data Source to Connect AS400

How to define the connection string for your data source?  You  can create a new connection, a data source based on an existing connection, a data source based on another object, such as an existing data source in your solution.

To create a data source based on a new connection:

1.      In Solution Explorer, right-click the Data Sources folder, and then click New Data Source



2.      On the Welcome To The Data Source Wizard page, click Next.

3.      On the Select How to Define the Connection page, verify that Create A Data Source Based on An Existing Or New Connection is selected, and then click New.

4.      The connection manager dialog box appears with Native OLE DB\SQL. Native Client selected in the Provider drop-down list.

5.      Select Microsoft OLE DB Provider for DB2.

6.       Type the name of the AS400 in the Server of file Name box.

7.      Select Use a specific user name and password.

8.      Type a valid user in AS400 in User Name box.

9.      Type a valid password in the password box.

10.  Check the Allow saving password box.

11.  Type the name of the AS400 in the Initial Catalog box. Your screen looks like this:



12.  Click All. 

13.  Check that “DB2/AS400” is typed in DBMS Platform box.

14.  Type a valid library in Default Schema box.

15.  Check that 437 is typed in  Host CCSID box.

16.  Type the system name of the AS400 in the Network Address box.

17.  Type QGPL in the Package Collection box.

18.  Check that True is typed in the Process Binary as Character box. Your Screen looks like this.





 19.  Click the Test Connection button and verify that it is successful.  Then click OK Twice.


Note   The New Connection SYSTEMNAME should now appear in the Data Connection pane.

If an authorization error appear  please check  that he user needs to have DRDA permissions to access the Host (AS400).

            DRDA : IBM Protocol Distributed Relational Database Architecture.

20.  Click Next.  The Completing The Wizard page will appear, and a default data source name is displayed in the Data Source Name box.

21.  Click Finish. The new data source will appear in the Data Sources Folder in solution Explorer.





Categories: Miscellaneous
Rate this article:


Other posts by AlbertoMunera

Please login or register to post comments.