|
Frequently Asked Questions
1) Can I load data into MySQL database hosted in
Shared Web Hosting.
Ans. Yes! you can use Data Loader to easily load data
from any database to MySQL database hosted in Shared Web Host. To do this you
have to first logon to CPanel and then add your IP address to access the
database as shown below
(CPanel/MySQL Databases Screenshot)
To find out your IP you can go to the following
site whatismyip.com.
Once you have added your IP now start Data Loader and
type your domain name (for ex. dbload.com) and user account and password and
click connect.
2) Can I use Data Loader to load data from Oracle or MySQL which is installed on
Unix Machine to any other Database.
Ans. Yes, you can load data from Oracle or MySQL which is
installed on another O/s. For this you must have proper Client Software
installed on the machine where you are running Data Loader.
3) Can I convert Delimited Text File to another Delimited Text, Fixed Length
format and Vice Versa
Ans. Yes, you can use Data Loader to Convert Delimited Text
files to another Delimited Text File or Fixed Length. You can even filter
columns and Specify WHERE conditions while converting.
4) Can I use Data Loader to Load data from one Oracle Ver. to Another Oracle
Version.
Ans. Yes, you can use Data Loader to load data from one Oracle
version to another Oracle Version.
5) Is there any limit on number of rows which data loader can load.
Ans. No, Data loader can be used to load millions of rows.
Our many existing customers are doing that. The Trail version is limited to load
not more than 50 Rows. But if you purchase a registered version of Data Loader
this restriction will be removed
6) Can I use WHERE Condition for filtering rows.
Ans. Yes, you can filter rows while loading from MySQL, Oracle, MS-Access,
MS-SQL Server Foxpro Database source to any other Target Database or Text file.
7) What other components are required to run Data Loader.
Ans. You should have Microsoft Data Access Components
(MDAC) Ver. 2.0 or later installed in your system. From Windows 2000 onwards
this component is automatically installed when you installed windows 2000. If
you are running Windows 98 or 95 then please first install MDAC before running
Data Loader. You can download MDAC
clicking here.
8)
How do I check whether MDAC is installed or not?
Ans. First go to control panel/Administrative Tools if you
see the ODBC Manager. Then MDAC is installed otherwise not.
9)
How do I remove the restriction of 50 Rows.
Ans. This happens if you are running Trial Version of Data
Loader. If you want to remove this restriction please purchase a registered
version of Data Loader.
10) Does Data Loader runs Conversion jobs at schedule date and time.
Ans. Yes, Data Loader Ver 2.0 comes with its own Scheduler.
Just create a session specify the schedule time and DL will executes the
conversion jobs periodically at specified times.
11) Which Databases are supported in the new version of Data Loader.
Ans. Currently Data Loaders Support loading to and fro from
MS-SQL Server, MySQL, Oracle, MS-Access, FoxPro, Text format.
12)Can I do transformation in Data Loader.
Ans. Yes by using views. For example: suppose you want to load columns from
multiple tables which are joined on some field to another Database. To achieve
this first create a joined view in your Oracle or MS-SQL Server Database and
then start Data Loader and select this view in the source and load it into any
of the databases.
13) Can I load from multiple Text or CSV Files
simultaneously
Ans. Yes, from Data Loader Ver. 2.5 you can load from multiple text files
simultaneously. Even if you have different delimited files in one folder you can
select these files and load it into any of the supported database.
14) Can I specify WHERE condition while loading data
from delimited text files.
Ans. Yes, from Data Loader Ver. 2.5 you can specify WHERE condition to filter
rows while loading from Delimited Text Files to any other supported Databases.
15. Connection problem while connecting to MySQL
Databases.
Ans. This usually happens because of Firewall. If you have a firewall install
then firewall software will not allow Data Loader to connect to MySQL Server. To avoid
this please allow Data Loader to access your computer by modifying firewall
settings. If Firewall settings are OK and still you are not able to connect
MySQL database then, please make sure you have MySQL ODBC Driver Ver. 3.51
installed in your system. If you don't have MySQL ODBC 3.51 Driver, you can
download the same by
clicking
here.
http://dev.mysql.com/downloads/connector/odbc/3.51.html#win32
16. Does Data Loader Supports Excel?
Ans. Yes, if you have save the data in CSV format.
17) Which Operating System is required to run Data Loader
v 2.5
Ans. All windows platforms are supported.
If you have any other questions or problems please contact us and we will be
glad to help you.
For Technical Support:
support@dbload.com
For General Support: sales@dbload.com
|
