Gateway 11.6 FHD 2-in-1 Convertible Notebook, Intel Celeron, 4GB RAM, 64GB Storage, Tuned by THX Audio, Mini HDMI, Cortana, Webcam, Windows 10 S, Microsoft 365 Personal 1-Year Included. Gateway Updater is a Shareware software in the category Miscellaneous developed by Gateway Incorporated. It was checked for updates 157 times by the users of our client application UpdateStar during the last month. The latest version of Gateway Updater is currently unknown. It was initially added to our database on.
- Gateway LT41P Card Reader Driver 4.3.0.7 for Windows 8 175 downloads. Card Readers Gateway. Jun 19th 2017, 20:18 GMT. Acer Aspire E5-731.
- Gateway Camera Driver free download - Driver Easy, EOCP Driver for Sony Eyetoy USB Camera, Magic Camera, and many more programs.
Note
We recently revised the on-premises data gateway docs. We split them into content that's specific to Power BI and general content that applies to all services that the gateway supports. You're currently in the Power BI content. To provide feedback on this article, or the overall gateway docs experience, scroll to the bottom of the article.
After you install the on-premises data gateway, you need to add data sources that can be used with the gateway. This article looks at how to work with gateways and Oracle data sources either for scheduled refresh or for DirectQuery.
Connect to an Oracle database
To connect to an Oracle database with the on-premises data gateway, the correct Oracle client software must be installed on the computer running the gateway. The Oracle client software you use depends on the Oracle server version, but will always match the 64-bit gateway.
Supported Oracle versions:
- Oracle Server 9 and later
- Oracle Data Access Client (ODAC) software 11.2 and later
Gateway Drivers Download Site
Install the Oracle client
- download and install the 64-bit Oracle client.
Note
Choose a version of Oracle Data Access Client (ODAC) which is compatible with your Oracle Server. For instance, ODAC 12.x does not always support Oracle Server version 9.Choose the Windows installer of the Oracle Client.During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Some versions of the Oracle client wizard selects the checkbox by default, others do not. Make sure that checkbox is selected so that Power BI can connect to your Oracle database.
Gateway Drivers Update
After the client is installed and ODAC is configured properly, we recommend using PowerBI Desktop or other test client to verify correct installation and configuration on the Gateway.
Add a data source
For more information about how to add a data source, see Add a data source. Under Data Source Type, select Oracle.
After you select the Oracle data source type, fill in the information for the data source, which includes Server and Database.
Under Authentication Method, you can choose either Windows or Basic. Choose Basic if you plan to use an account that's created within Oracle instead of Windows authentication. Then enter the credentials to be used for this data source.
Note
All queries to the data source will run using these credentials. To learn more about how credentials are stored, see Store encrypted credentials in the cloud.
After you fill in everything, select Add. You can now use this data source for scheduled refresh or DirectQuery against an Oracle server that's on-premises. You see Connection Successful if it succeeded.
Advanced settings
Optionally, you can configure the privacy level for your data source. This setting controls how data can be combined. It's only used for scheduled refresh. The privacy-level setting doesn't apply to DirectQuery. To learn more about privacy levels for your data source, see Privacy levels (Power Query).
Use the data source
After you create the data source, it's available to use with either DirectQuery connections or through scheduled refresh.
Warning
The server and database names must match between Power BI Desktop and the data source within the on-premises data gateway.
The link between your dataset and the data source within the gateway is based on your server name and database name. These names must match. For example, if you supply an IP address for the server name within Power BI Desktop, you must use the IP address for the data source within the gateway configuration. This name also has to match an alias defined within the tnsnames.ora file. For more information about the tnsnames.ora file, see Install the Oracle client.
This requirement is the case for both DirectQuery and scheduled refresh.
Use the data source with DirectQuery connections
Make sure that the server and database names match between Power BI Desktop and the configured data source for the gateway. You also need to make sure your user is listed in the Users tab of the data source to publish DirectQuery datasets. The selection for DirectQuery occurs within Power BI Desktop when you first import data. For more information about how to use DirectQuery, see Use DirectQuery in Power BI Desktop.
After you publish, either from Power BI Desktop or Get Data, your reports should start to work. It might take several minutes after you create the data source within the gateway for the connection to be usable.
Use the data source with scheduled refresh
If you're listed in the Users tab of the data source configured within the gateway and the server name and database name match, you see the gateway as an option to use with scheduled refresh.
Troubleshooting
You might encounter any of several errors from Oracle when the naming syntax is either incorrect or not configured properly:
- ORA-12154: TNS:could not resolve the connect identifier specified.
- ORA-12514: TNS:listener does not currently know of service requested in connect descriptor.
- ORA-12541: TNS:no listener.
- ORA-12170: TNS:connect timeout occurred.
- ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA.
These errors might occur if the Oracle client either isn't installed or isn't configured properly. If it's installed, verify that the tnsnames.ora file is properly configured and you're using the proper net_service_name. You also need to make sure that the net_service_name is the same between the machine that uses Power BI Desktop and the machine that runs the gateway. For more information, see Install the Oracle client.
You might also encounter a compatibility issue between the Oracle server version and the Oracle Data Access Client version. Typically, you want these versions to match, as some combinations are incompatible. For instance, ODAC 12.x does not support Oracle Server version 9.
For diagnosing connectivity issues between the data source server and the Gateway machine, we recommend installing a client(such as PowerBI Desktop or Oracle ODBC Test) on the gateway machine. You can use the client to check connectivity to the data source server.
For additional troubleshooting information that relates to the gateway, see Troubleshooting the on-premises data gateway.
Next steps
More questions? Try asking the Power BI Community.
- vista x64-bit driver
- canon mf 4410 x64-bit driver
- lenovo acpi vpc2004 x64-bit driver
- canon lbp 3200 64 bit x64-bit driver
- ecs g31t m7 v1 0 lan driver x64-bit driver
- fsb 1333 g31t m7 v1 0 chipset driver x64-bit driver
- dell vostro 1015 x64-bit driver
- canon mf 4400 x64-bit driver
- atheros wireless lan driver x64-bit driver
- realtek ethernet drivers x64-bit driver
- canon lbp 810 x64-bit driver
- dell optiplex 380 ethernet x64-bit driver
- dell inspiron n5110 sm bus controller x64-bit driver
- dell optiplex 780 drivers x64-bit driver
- canoscan lide 20 x64-bit driver
- canoscan 3000ex x64-bit driver
- asus epu 6 engine utility x64-bit driver
- realtek 8112l x64-bit driver
- atheros ar8112 10 100 lan x64-bit driver
- nvidia mcp78 chipset driver x64-bit driver
- qualcomm gobi 2000 3g module driver x64-bit driver
- gigabyte g41 lan driver xp download x64-bit driver
- ecs g31t m7 v1 0 chipset driver x64-bit driver
- canon mf3110 64 bit x64-bit driver
- atheros ar8132 x64-bit driver
- dell optiplex 790 sm bus controller x64-bit driver
- canon laserbase mf5730 mf5750 mf5770 x64-bit driver
- canon lbp 5200 64 bit x64-bit driver
- ati radeon x1250 driver x64-bit driver
- dell vostro 1000 drivers x64-bit driver