data explorer: test pdo_oci for direct connections.

[isangil]

Would be interested if the DE could talk to Oracle directly.

[isangil]

well, tested a bit pdo_oci.

download pack - into includes/database/oci

modify the settings local to include a connector.

not sure the connector was right.

$databases['oracledata']['default'] = array(
'database' => '========',
'username' => '========',
'password' => '========',
'host' => 'localhost',
'port' => '1521',
'driver' => 'oci',
'prefix' => '',
);

what is im unsure about? well, the port, etc.

how i tested? tried to see the connector in the widget provided by schema_reference.

[isangil]

not successful, postponing.

[isangil]

the reasons could be many.

1- may need a php native driver -- this was run in solaris, which runs an oracle11g DB and some clients. Im pretty sure it may not have a php-oci driver.
2- who knows whether the connector is right. i tried some variations, but not all possible changes.

i can try testing accessing from a ubuntu instance, installing a client over there. not sure that'd be successful.

[isangil]

Some more testing. the http://drupal.org/project/oci8 bills itself as a lighter weight module meant for connections to external oracle DBs, in a way, perhaps more synergistic with our goals. the approach, as claim, is to wrap the current connectivities around oci8 commands, to enable such conn.

however, it did not work for me. granted, im using 'schema-reference', that may need the actual driver and the abstraction layer in includes/database/oci (or something).

what i did:

install the oci8 module. create a connector as the previous in settings local. no work. so, create a conector as suggested in the module page

/**

• Database connection settings for the oci8 module. These settings
• mimic Drupal's main $databases variable.
  */
  $conf['oci8'] = array(
  'databases' => array(
  'default' => array(
  'default' => array(
  'database' => 'DATABASE_NAME',
  'username' => 'DATABASE_USER_NAME',
  'password' => 'DATABASE_PASSWORD',
  'hosts' => array('HOST_A', 'HOST_B'),
  'port' => 'PORT_NUMBER',
  ),
  ),
  ),
  );

variations of this: with/o port and with port. no work yet.