Page Version 10 Drupacle Drupacle Page DrupacleAn Overview Drupaclea simple drupal8 moduleprovides a simple way to connect to any oracle databasesKey benefits includeOracle connection as drupal e ID: 851154
Download Pdf The PPT/PDF document "Oracle Database Connection Tool for Drup..." is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
1 Page Version 1.0 Drupacl
Page Version 1.0 Drupacle Oracle Database Connection Tool for Drupal Drupacle Page DrupacleAn Overview Drupaclea simple drupal8 moduleprovides a simple way to connect to any oracle databases.Key benefits include:Oracle connection as drupal entityOracle connection entity management.Short Code for each connection objectWith Drupacle, you can add connectionwhich will generate a short to query the oracle databases.How it WorksAdd a
2 oracle connection with proper details fr
oracle connection with proper details from admin section.On the listing page clickgeneratedshort code textarea which will copy the short codeUse the copied short code connection object to query to oracle database. Drupacle Page Getting Started This chapter provides quick start information about the Drupaclemodule.2.1PrerequisitePHP in your server should must have OCI driver(Oracle Driver) latest version installed and enabled. You can install Orac
3 le driver in your server by referring th
le driver in your server by referring this link https://www.oracle.com/technetwork/articles/dsl/technoteinstant2088811.html After installation your phpinfo() should have this 2.2Install DrupaclemoduleInstall the drupacle module and set the permissions. Drupacle Page 2.3Drupacle connection as ENTITYEvery Drupacle connection is an entity.To to the listing pag, follow these steps:Enter the link in your drupal site /admin/drupacle/connections/ Func
4 tionality (Menu Option) Associated Feat
tionality (Menu Option) Associated Features Add Oracle DB connectionCreate new Oracle DB connection SHORT CODE Click on textarea to copy short code to use on your file. OPERATIONS EditEdit an existing connection details OPERATIONS DeleteDelete an existing connection details ListingListing of all connections 2.3.1Add Oracle ConnectionYou have to fill the form to create connection.When you click on Add Oracle DB connectionbutton page will redirect to
5 admin/drupacle/connection/add Drupacle
admin/drupacle/connection/add Drupacle Page From the field name it is clear that what values should be fill to the form.After submitting the form a new connection will be get created. Connection Status Description SuccessDB Connection to oracle database is successful. FailedDB Connection to oracle database is failed with error. Now once oracle db connection is successful, Drupacle module provides service to create an object which you can use to
6 query oracle database connected. Drupacl
query oracle database connected. Drupacle Page Step 1: Use following namespace in your own file use DrupaldrupacleControllerDrupacleController; Step 2: Copy the short code from listing page and use as follows Example You cause dependency injection as follows $entity_storage = $this�entityManager�getStorage('drupacle_connection'); $entity = $entity_storage�load("machine_name"); $connObj = $this�drupacleService�
7 000;drupalConnectionCallback($entity); $
000;drupalConnectionCallback($entity); $Sql = oci_parse($connObj["machine_name"], "select * from table"); Lables Description Connection nameCONNECTION name is a unique machine name of drupacle connectionSuch as “oracle3” 'drupacle_connection'Drupacle connection entity type Drupacle Page 2.3.2Edit ConnectionFromOPERATIONS you can edit the existing connection 2.3.3Delete Connection:FromOPERATIONS you can deletethe existing connect