Skip to Content

  Below we will see, how we can create an OLTP connection using a non-SAP data source and publish it to repository.

1)      1) First create a .mdb or .accdb file which will be used as the source file.

2)      2) Then create a DSN – ODBC Data source based on mdb file. In Run, type ODBC and select ODBC Data source administrator. Click Add.

          Untitled.png

1)      3) Select Microsoft access driver and click finish.

    

          Untitled.png    

E          4) Enter the data source name and click Select.

         

          Untitled.png

5         

          5 ) Here locate your file from your computer and click OK. Your data source has been created.

    

     Untitled.png    

          6) Now Open Information designer tool and create a new session.

          7) After creating a session, create a new project. Give a project name and click Finish.

          Untitled.png

             8) After creating the project, create a relational connection. Right click on the project, select New and select Relational connection.

              

               Untitled.png

               9) Give the name of relational connection and select MS Access 2007 ODBC Drivers and click Next. On the next screen Test conection and click Finish.

               Untitled.png

         

               Untitled.png

              

                    10) The relational connection is created and the screen will look like this.

              

                    Untitled.png

               11) After that, we need to publish the connection to Repository. Right click on the .cnx file and click Publick connection to a repository.

                     Follow the steps and click Finish.

                    Untitled.png

              

                    Untitled.png

5)

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply