Connect to Sybase IQ (Power Query)

Notes: 

• Power Query is known as Get & Transform in Excel 2016. Information provided here applies to both. To learn more, see Get & Transform in Excel 2016.

• Before you can connect to an SAP SQL Anywhere database, you need the  SAP SQL Anywhere driver installed on your computer. Select the driver that matches your Power Query installation (32-bit or 64-bit).

1. In the POWER QUERY ribbon tab, select From Database > From Sybase Database.

   

2. In the Sybase Database dialog box, specify the Sybase Server to connect to in the Server Name box. Optionally, you can specify a Database Name as well.

3. If you want to import data using a native database query, specify your query in the SQL Statement box. For more information, see Import Data from Database using Native Database Query.

4. Click OK.

5. By default, the Encrypt connection check box is selected so that Power Query connects to your database using a simple encrypted connection.

6. Click Connect.

Related Topics

Import data from external data sources