Importing Data using ODBC connection

26 posts / 0 new
Log in or register to post comments
Last post
Tue, 02/07/2017 - 11:05
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
 

Top
Tue, 02/07/2017 - 11:16
(Reply to #22)
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

Top
Tue, 10/01/2019 - 17:40
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: 
Top
Mon, 11/11/2019 - 11:59
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!

Files: 
Plain text icon Redacted Import.txt
Top
Tue, 02/11/2020 - 14:49
jppayan16
Offline
Joined: 02/11/2020 - 14:40

Hi, all
I have too many tables in Oracle, I need to import a lot of and specifics fields, how can i do? help me please!!!
 
 

Top

Pages