address: address: port/api.rsc/CustomersĪs with standard OData feeds, if you wish to limit the fields returned, you can add a $select parameter to the query, along Since we are working with Angular, we will append the parameter to the end of URLs that do not return JSON data URLs, you will need the address and port of the API Server. For information on accessing the tables, youĬan navigate to the API page for the API Server (click the API link on the top right of the API Server Web page). Below, you will see the URLs to access tables and the list of tables. Having configured a connection to Oracle, created a user, and added tables to the API Server, we can access OData feedsįor those tables. Select the tables you wish to access and click Save Changes. To enable tables, click the Add Resourcesīutton on the Resources tab of the Settings page. Having created a user, we are ready to enable access to Oracle entities as tables. The API Server with the read-only user, using the associated authtoken. We also allow connections from all IP addresses.Īs you can see in the screenshots, we already had a user configured with read and write access. Click Add, give the User a name, and select GET for the Privileges. Since we are only creating a simple SPA for viewing data, we will create a user that has read-onlyĪccess. You can add and configure users on the Users Next, create a user to access your Oracle data through the API Server. Service Name: The service name of the Oracle database.Password: The password provided for authentication with the Oracle database.User: The user Id provided for authentication with the Oracle database.Port: The port used to connect to the server hosting the Oracle database.Once you've done this, set the following to connect: The native DLLs can be found in the lib folder inside the installation directory. To connect to Oracle, you'll first need to update your PATH variable and ensure it contains a folder location that includes the native DLLs. Name your connection, select Other as the database, set the ADO.NET Provider (), and build a connection string To configure the API Server to connect to your Oracle data, you will need to navigate to the Connections tab on the
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |