By typing " help" we get a list of the content from the AdventureWorks Database:ģ. Test the connectivity with the " iusql" command from the unixODBC Manager: The Result should look as follows and you should not see any " not found" entry:Į. Check the Library deoendency of the " libmsodbcsql-11.0.so.2260.0" file with:ĭ. Navigate to "/opt/microsoft/msodbcsql/lib64/".Ĭ. If it doesnt run on OS Level, it will never run on SAP HANA Level.ī. In the next Step we will test the connectivity outside SAP HANA. In order that your SAP HANA Instance takes notice of this Environment Variable you need to restart your Instance. Navigate to your Home Directory and open your Profile File. Paste the following content after you adjusted it your your Environment:ĭriver=/opt/microsoft/msodbcsql/lib64/libmsodbcsql-11.0.so.2260.0 Navigate to " /opt/microsoft/msodbcsql/lib64".ī. Now we can go ahead and configure everything after the Installation.Ī. the Driver has been installed to the location " /opt/microsoft/msodbcsql".Ģ.3 Configure the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP The Installation of the Microsoft ODBC 11 for SQL Server - SUSE Linux CTP Driver has been completed successfully. Verify if your SAP HANA Host completes all Prerequisites: We now continue and instakk the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP Driver.ī. The installation of the unixODBC Manager 2.3.0 is completed successfully.Ģ.2 Install the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP Driver Navigate to the Folder which is highlighted in the lower red rectangle.Ĭd /tmp/unixODBC.16887.29613.12297/unixODBC-2.3.0 build_dm.sh -download-url=file:///mnt/sapmnt/software/nonsap/linux/microsoft/unixODBC-2.3.0.tar.gz Start the Installation of the unixODBC Manager: Remove any older Version of the unixODBC Manager.Į. You will also find some steps to test the Installation outside SAP HANA.Ģ.1 Installation of the unixODBC Manager 2.3.0įirst we start with the Installation of the unixODBC Manager 2.3.0.ī. In this Chapter you will find the Installation and Configuration steps for the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP. Please check the " System Requirements" section of the Driver for more Information.Ģ. The System Requirements for the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP have been met. The Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP Driver and the unixODBC Manager 2.3.0 is downloaded somewhere No Firewalls are blocking the connection Both Hosts can communicate with each other Access (root, sidadm/Administrator) to both Hosts is given MS SQL Server is installed and working properly SAP HANA is installed and working properly The following is an Assumption that needs to be considered prior of following these Instructions: The " Install Instructions" section of the Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTPĭownload Microsoft® ODBC Driver 11 for SQL Server® - SUSE Linux Community Technology Preview from Of. The SAP HANA 1.0 SPS10 Administrators Guide ( ) The following Documentation helped during the whoe process: Microsoft ODBC Driver 11 for SQL Server - SUSE Linux CTP AdventureWorks DW 2012 Sample Database for Microsoft SQL Server 2012 Microsoft SQL Server 2012 Express Edition on Microsoft Windows Server 2012 R2 102) on SUSE Linux Enterprise Server 11.3 for SAP The following Software and its Versions are used: Please consult the official documentation for the correct process. This Documents excludes the process of installing and configuring SAP HANA and MS SQL Server 2012. These Information are Resources, Guides, Links, etc. Please find here some Information before we start. This Document will show you the rest of the required Information. But, as so often, it tells only half the truth. The official Documentation guides you to the right direction. In the nature of things it is quite tricky to connect a Linux based Application (In our case SAP HANA 1.0) to a Microsoft Windows based Application (In our case MS SQL Server 2012). This Document will cover the connectivity between SAP HANA 1.0 and MS SQL Server 2012 for SDA and SDI. Also available is the Hadoop Integration. These are " Smart Data Access" (SDA) and " Smart Data Integration" (SDI). There are several Data Provisioning techniques available within SAP HANA.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |