Importing Data using ODBC connection

25 posts / 0 new
Last post
paarth
Offline
Joined: 02/04/2017 - 21:34

thanks Mr. brian
now i will need ur help when actually i have to iimport data
ur guidance that time will help a lot
 

Brian Element's picture
Brian Element
Offline
Joined: 07/11/2012 - 19:57

Ok Paarth,

Let me know and I will try and help you out.

Brian

jarcea01
Offline
Joined: 09/02/2019 - 21:44

Hi Brian
with any permission you must have an ORACLE user to access the tables in IDEA through ODBC.
Connecting to the ORACLE database through ODBC does not display the tables.
 
 

Images: 
JHDCC
Offline
Joined: 02/15/2017 - 11:28

Hi all.

I have managed to amend the Oracle ODBC script to meet my needs, however, I am now seeking to improve it and remove the need to make manual amendments. As can be seen in the attachment, I have had to include a payment date in the SQL parameters for the import.

Is it possible to add variables that are not included on the dialogue box? I would like to pull from eg the user entering 19/20, a "FROM" date of '01-APR-2019' and a TO date of '31-MAR-2020' which can be used in the SQL.

Currently, if a user was to enter 17/18 in the Financial Year, I would expect it would bring back no results, due to my fixed SQL parameters.

I did have a thought that I could include a file or database with a list of dates, financial years and start and end dates to look up to, however, that may be overcomplicating things at this stage!

Pages