Saving a Datasource programmatically

Question

Lambert Desa 2021-7-4

1
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/871738-saving-a-datasource-programmatically

评论： Lambert Desa 2021-7-5

Dear Community,

I am currently at the basic level of using MATLAB to solve data analytics problems. This day I have been trying to connect to an Oracle Database in order to access available data tables, load and analyse certain portions of these data tables. I succesfully established a connection to the database as shown below, the connection does exist and is open.

I however have not been able to save this created conection ("DS_Conn") as a Datasource, so I can easily call it up through the datasource option in the Database Explorer Menu. Herewith is my editor code:

% Connect to oracle Database
datasource = 'DDSA_DB'
driver = 'oracle.jdbc.driver.OracleDriver'
url = ['jdbc.roacle.tin:@(DESCRIPTION = '…
    '(FAILOVER = ON)(LOAD_BALANCE = OFF)(ADDRESS_LIST ='…
    '(ADDRESS = (PROTOCOL = TCP)(HOST = XXX.XX.XX.XXX)(PORT = 1521)))'….
    'CONNECT_DATA = SERVICE_NAME = DDSA)))'];
%
username = "XXXXXXX";
password = "xxxxxxxxxxx";
%
DS_Conn = database(datasource,username,password,dirver,url); % Connection established and is open []. 
saveAsJDBCDataSource(DS_Conn); % Request fails with error message that "DS_Conn" is unknown.
%

Furthermore, a request to list all tables within the database accessible with my account only generates an error, despite existing database connection.

sql_select = sprintf(selectowner, table_name from all_tables); % error message

I most probably should be missing something, will very much appreciate your hints or any form of assistance.

P.S: Creating a connection using the "Database Explorer App" failed strangely enough, can't identify why.

Thanks

Desa

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Sulaymon Eshkabilov 2021-7-4

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/871738-saving-a-datasource-programmatically#answer_739808

The last line in your posted code: saveAsJDBCDataSource() is not MATLAB's builtin fcn unless you have your own or 3rd party fcn file that has to be fixed.