Connect to SAP Sybase SQL Anywhere (Power Query)

Use Excel's Get & Transform (Power Query) experience to connect to an SAP SQL Anywhere database.

Notes: 

  • 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).

Click the Data tab, then Get Data > From Database > From Sybase Database. If you don't see the Get Data button, click New Query > From Database > From Sybase Database.

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

  2. 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.

  3. Click OK.

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

  5. Click Connect.

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

    Get External Data from a Database
  2. In the SAP Sybase SQL Anywhere 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.

See Also

Power Query is known as Get & Transform in Excel 2016

Import data from external data sources

Expand your skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×