Auto Connection between Oracle and SQL Database

I have more than 9 years of experience in IT industry. I can provide you better solution. Relevant Skills and Experience . Net, SQL server, Oracle

Hi, I'm a software developer with over 5 years of experience working on various tools and technologies. I'm pursuing my master's in data science from Trinity College Dublin and interested in your work. I assure you a quality delivery within the timeframe. Thanks, Tousif

Hi, I am interested in your project. I can do integrator fast and simple. Need info about database structure. Please feel free to contact me with more details about your project. I can use C# and Delphi as client of database. I have exp on ERP & Account system include 1c: ERP and more. I am a full time programmer with 20 year exp in Russia. I have hi degree in information system in economics.

Hi,  I am a Full stack developer in Microsoft technologies.  My area of expertise is web application development (asp.Net web forms, MVC, classic ASP), web services (SOAP & RESTFul), MySql & Sql Server as back end (through stored procedures).  I have 6 years of experience as a full time software developer.  Kindly contact me, lets discuss your requirements.

Have gone through the requirements, will be able to do that in JAVA. Kindly let me know if you are already having queries which update data from one Database to other or if you can demonstrate the manual workflow, wanted to see the logic on which data is being uploaded. Kindly let me know for more details, if this works for you. Will be glad to work with you.

I have totally 30 yrs of software development with database design and 10 years of Senior Oracle DBA experience (mostly on Oracle 8i, 9i, 10g, 11g with frontend D2K, JAVA, VB, .Net) in different sectors namely Automobiles, FMCG, Banking, Pharmaceuticals, Publishing House, Civil Construction, Textiles Weaving & Fabric Export, Chemicals Export, Sales Chain & CRM, Finance with Branch wise/Divn Wise P/Loss & B/Sheet (Schedule VI) & apportionment, Textiles Inventory, ERP on manufacturing, Database and Application Migration from Oracle 8i(windows) to Oracle 10g(AIX 5.3l) and Oracle 10g AS, Outstanding Analysis, Debtors/Creditors List, Age Analysis, Yarn Management etc. EXPERIENCE SUMMARY Experience in Application Development/DB Admin on Oracle 8i/9i/10g/11g(Rel2) Initial Planning for Database Creation & Schema Designing Oracle 8i/9i/10g/11g Installations (OEL 6.3AIX 5.3L; RHEL AS 4.0; HPUx-11i) Oracle ASM, RMAN, Data guard configuration, DB Tuning, etc. Resource Planning, Client and User Interaction, Allocation, Job spec scheduling. Project Planning, Man power allocation, Form Design, Programming [10g AS]. Unix Scripting, etc. Also proficient in :- Oracle (9i/10G/11G) Database Administration Oracle Application Development Oracle 10g AS for Forms & Reports (Application Server in HP-Ux11i) Oracle 10g DS for Forms & Reports (Windows Client) Oracle SQL/PLSQL Java (J2EE) Language Programming Oracle ADF (ver 10g & 11g) Moderate knowledge Unix Shell Scripting AIX 5.3 L HP-Ux 11i RHEL 6.9

I am an Oracle SME and I am new on this freelancer. So want to do my first project in almost in free of cost with minimum charges.

i can do this project with the help of SSIS(Sql server intergration server). i have good knowledge on both SQL Server and ORACLE database.

Dear Employer, This task can be achieved using Oracle ODBC Connection to fetch/push data from Oracle Database to SQL Database. To push/fetch data from SQL Database, you can use Linked Server to Oracle. We can do this task. Please accept my bid. Thanks, Vipul Maheshwari

Over 7 years’ experience of in IT Industry working as DBA, I had experience of doing similar work in past.

Solution # 1 Using Apache Sqoop connect to SQL Server and pull the data into staging area such as Hadoop distributed file system. Them Export it back into Oracle database and vice-versa. You will need a cloudera CDH5.13 cluster which is free. Or Solution # 2 Using Shell scripts Import / export data from dual databases and vice-versa.